﻿using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
namespace INTEX.DataBase.Tools
{
    public partial class INTEXDBC
    {
        public void MapWBBST(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SaveWBBST(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryWBBST(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapWBBST(ref dwLocal, dwData);

            if (!flgExist)
            {
                InsertWBBST(dwLocal, ITXDBVERSION);
            }
            UpdateWBBST(dwLocal, 1);
        }
        public void InsertWBBST(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "INSERT INTO WBBST(WBBMANDANT, WBBRWKRS, WBBRWLFD, WBBPOS, WBBWERK, WBBABT, WBBKUNDNR, WBBSTKNR, WBBWAKZ, "
            + "WBBART, WBBDESS, WBBCOLORIT, WBBFARBE, WBBBESCHICH, WBBVAR, WBBKOLL, WBBVKART, WBBVKFARBE, WBBARTABW, WBBARTKUNDNR, WBBENTWKZ"
            + ", WBBSSTKLG, WBBSGEW, WBBSBRT, WBBISTKLG, WBBIGEW, WBBIBRT, WBBBRGEW, WBBDM, WBBVOL, WBBIGEWKZ, WBBIANZ, WBBMABRT1, WBBMASTKLG1, "
            + "WBBMABRT2, WBBMASTKLG2, WBBMABRT3, WBBMASTKLG3, WBBMABRT4, WBBMASTKLG4, WBBMABRT5, WBBMASTKLG5, WBBINDAT, WBBINBSTMTR, "
            + "WBBINBSTKG, WBBIPREIS, WBBWARSCH, WBBWDATUM, WBBWSCHICHT, WBBWMNRKRS, WBBWMLFDNR, WBBWMPOS, WBBRE, WBBRENETTO, WBBREVGUET, "
            + "WBBRS, WBBRSNETTO, WBBRSVGUET, WBBVE, WBBVENETTO, WBBVEVGUET, WBBVS, WBBVSNETTO, WBBVSVGUET, WBBANZTEILE, WBBVERSION, WBBTAX, "
            + "WBBZENSUR, WBBZENSURKZ, WBBUBRT, WBBZAFOLGE, WBBNAFOLGE, WBBZLNR, WBBAUFMSL, WBBZUSAM, WBBMAART, WBBPACKTYP, WBBROLLR,"
            + "WBBAUFMPOS, WBBKONFKZ, WBBKETTELN, WBBSHSTK1, WBBSHBRT1, WBBSHSTKLG1, WBBSHSTK2, WBBSHBRT2, WBBSHSTKLG2, WBBSHSTK3,"
            + "WBBSHBRT3, WBBSHSTKLG3, WBBSHSTK4, WBBSHBRT4, WBBSHSTKLG4, WBBSHSTK5, WBBSHBRT5, WBBSHSTKLG5, WBBSTKNRK, WBBLO, "
            + "WBBLB, WBBKZ, WBBLP, WBBAUFBKZ, WBBGEBNR, WBBGEBPOS, WBBSPSTA, WBBSPGRD, WBBERLKZ, WBBAUFTYP, WBBAUFKRS, WBBAUFLFD, "
            + "WBBAUFPOS, WBBTP, WBBFOLGE, WBBAFOLGEVON, WBBRAFOLGE, WBBMAFOLGE, WBBRSTKLG, WBBRGEW, WBBLGAE, WBBGEWAE, WBBPOOL,"
            + " WBBAUTZU, WBBWDUPOS, WBBRBENID, WBBRDATB, WBBRDAT, WBBRBEM, WBBRKUNDNR, WBBDPART, WBBDPART2, WBBZUSTAND, WBBFARBN, WBBSPKZ,"
            + " WBBCUKZ, WBBDISPOART, WBBDISPOVAR, WBBAUSFFRB, WBBAUSFGRI, WBBAUSFQUAL, WBBQUALST, WBBQPKT, WBBQPKTH, WBBQPKTL, WBBQPKTLH, "
            + "WBBVB, WBBVG, WBBVLVB, WBBVLVG, WBBVLSACHB, WBBVLGEGEN, WBBPRKUNDNR, WBBGENNR, WBBELOA, WBBELOB, WBBURAUFKRS, WBBURAUFLFD, "
            + "WBBURAUFPOS, WBBVKNPOS, WBBURLAND, WBBVERZKZ, WBBTSTKLG, WBBTANZ, WBBURPOS, WBBTEILPOS, WBBECKZ, WBBTLGAFOLGE, WBBZMT,"
            + " WBBANZSNT, WBBTLBRT, WBBTLSTKLG, WBBTLRICHT, WBBDRKZ1, WBBDRKZ2, WBBEINDAT, WBBWSTKLG, WBBWBRT, WBBWBMNRKRS, WBBWBMLFDNR,"
            + " WBBWBMPOS, WBBSCHUSS, WBBWERKE, WBBLIEF, WBBBAHN, WBBBAHNMAX, WBBWLO, WBBWLB, WBBWLP, WBBWAUFBKZ, WBBKANTE, WBBSOLLKZ, "
            + "WBBMATAB, WBBWJJJJ, WBBWBNR, WBBFLZZUGDAT, WBBISTKLGFA, WBBISTKLGF, WBBFRTWSKZ, WBBLTPOS, WBBILGFBT, WBBILGRBT, WBBIBRTFV, WBBIBRTFB, "
            + "WBBFEUCHTE, WBBLIEFSCH, WBBKDPART, WBBSCHLICHTEKZ, WBBASWAKZ, WBBASART, WBBASVAR, WBBFARBEALT, WBBCOLALT, WBBDESSALT, "
            + "WBBBESALT, WBBZUSTANDA, WBBMASSKZ, WBBFJJJJ, WBBFBNR, WBBRETOURKZ, WBBREAUFKRS, WBBREAUFLFD, WBBREAUFPOS, WBBREAFOLGE, "
            + "WBBTPA, WBBKOMMNR, WBBALIEFSCH, WBBPACKNR, WBBPACKAUTO, WBBRUEKZ, WBBURLB, WBBURLP, WBBURAKZ, WBBVERSDAT, WBBVERSANDKZ, "
            + "WBBURLIEFSCH, WBBARECHNR, WBBFERTKZ, WBBEGKZ, WBBBEM, WBBTXSCHL, WBBHHK1, WBBHHK2, WBBHHK3, WBBHHK4, WBBHHK5, WBBHHK6, "
            + "WBBHHK7, WBBHHK8, WBBHHK9, WBBHHK10, WBBHHKG, WBBAHK1, WBBAHK2, WBBAHK3, WBBAHK4, WBBAHK5, WBBAHK6, WBBAHK7, WBBAHK8,"
            + " WBBAHK9, WBBAHK10, WBBAHKG, WBBABPZAB, WBBABDATAB, WBBNEUBEN, WBBNEUDAT, WBBAENDBEN, WBBAENDDAT, WBBAENDZL, WBBWS,"
            + " WBBWSNO, WBBFILLER)"
                    + " VALUES (:WBBMANDANT, :WBBRWKRS, :WBBRWLFD, :WBBPOS, '   ', '   ', '00000000', '            ', ' ', '                    ', '          ', '          ', '          ', '          ',"
                    + " '  ', '     ', '                        ', '          ', ' ', '        ', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '        ', 0, '0', '  ', '0000', '00', 0, 0, 0, 0, 0, 0, "
                    + "0, 0, 0, 0, 0, 0, '0', '1', '   ', '1', 'A', 0, '000', '000', '               ', '  ', '  ', ' ', '    ', 'I', '0000', ' ', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '            ', '  ', '  ', ' ', '        ', 'J', '        ', '000', '  ', '  ', 'J', ' ', '  ', '      ', '   ', '0000', '00', '000', '000', '000', 0, 0, 0, 0, ' ', ' ', '02', '        ', 0, 0, '               ', '        ', '           ', '           ', '    ', '  ', ' ', ' ', '                    ', '  ', 100, 100, 100, ' ', 0, 0, 0, 0, '   ', '   ', '   ', '   ', '        ', ' ', '        ', '            ', '  ', '  ', '  ', '000000', '000', 0, '   ', ' ', 0, '00', '0001', '0000', ' ', '000', 9, 0, 0, 0, ' ', ' ', ' ', 0, 0, 0, '  ', '0000', '00', 0, ' ', '0000', 0, 0, '  ', '  ', '        ', ' ', '  ', ' ', ' ', 0, 0, 0, 0, 0, ' ', 11, 0, 0, 0, 0, 0, '          ', '          ', 'J', ' ', '                    ', '  ', '          ', '          ', '          ', '          ', '    ', ' ', 0, 0, '  ', '  ', '000000', '000', '000', '0000', '000000', '00000000', '0000', ' ', ' ', '  ', '        ', ' ', 0, 'J', '00000000', '00000000', 'Z', ' ', '               ', '  ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '        ', 0, '        ', 0, 4, '    ', 0, '                                                                                                           ')";
            or1.Parameters.Add("WBBMANDANT", OracleType.NVarChar).Value = dwData["WBBMANDANT"].ToString();
            or1.Parameters.Add("WBBRWKRS", OracleType.NVarChar).Value = dwData["WBBRWKRS"].ToString();
            or1.Parameters.Add("WBBRWLFD", OracleType.NVarChar).Value = dwData["WBBRWLFD"].ToString();
            or1.Parameters.Add("WBBPOS", OracleType.NVarChar).Value = dwData["WBBPOS"].ToString();
            Connect2Proxy(or1);
        }
        public void DeleteWBBST(string sdkey, string key)
        {

            OracleCommand or1 = OracleDB.CreateCommand();

            string SDKEY = "00" + Left(key + "                       ", 21) + "V";
            or1.CommandText = "SELECT * "
            + " FROM SDDAT WHERE SDSA=:SDSA AND SDKEY =:SDKEY";
            or1.Parameters.Add("SDSA", OracleType.NVarChar).Value = sdkey;
            or1.Parameters.Add("SDKEY", OracleType.NVarChar).Value = SDKEY;
            Connect2Proxy(or1);
        }
        public DataSet QueryWBBST(DataRow dwData, int option)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            string qty = "0";
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM WBBST WHERE  ROWNUM<2 ";
                    break;
                case 1:
                    qty = dwData["WBBISTKLG"].ToString();
                    or1.CommandText = "SELECT * FROM WBBST WHERE WBBMANDANT=:WBBMANDANT "
              + " AND WBBDISPOART=:WBBDISPOART "
              + " AND WBBDISPOVAR=:WBBDISPOVAR "
              + " AND WBBWAKZ=:WBBWAKZ "
              + " AND WBBLO=:WBBLO "
                        //              + " AND WBBLB=:WBBLB "
              + " AND WBBDESS=:WBBDESS "
              + " AND WBBCOLORIT=:WBBCOLORIT "
              + " AND WBBBESCHICH=:WBBBESCHICH "
              + " AND WBBFARBE=:WBBFARBE "
              + " AND WBBAUFLFD='000000'"
              + " AND WBBISTKLG-WBBTSTKLG>=" + qty
              + " ORDER BY WBBSSTKLG ASC";
                    or1.Parameters.Add("WBBMANDANT", OracleType.NVarChar).Value = dwData["WBBMANDANT"].ToString();
                    or1.Parameters.Add("WBBDISPOART", OracleType.NVarChar).Value = dwData["WBBDISPOART"].ToString();
                    or1.Parameters.Add("WBBDISPOVAR", OracleType.NVarChar).Value = dwData["WBBDISPOVAR"].ToString();
                    or1.Parameters.Add("WBBWAKZ", OracleType.NVarChar).Value = dwData["WBBWAKZ"].ToString();
                    or1.Parameters.Add("WBBLO", OracleType.NVarChar).Value = dwData["WBBLO"].ToString();
                    //or1.Parameters.Add("WBBLB", OracleType.NVarChar).Value = dwData["WBBLB"].ToString();
                    or1.Parameters.Add("WBBDESS", OracleType.NVarChar).Value = dwData["WBBDESS"].ToString();
                    or1.Parameters.Add("WBBCOLORIT", OracleType.NVarChar).Value = dwData["WBBCOLORIT"].ToString();
                    or1.Parameters.Add("WBBBESCHICH", OracleType.NVarChar).Value = dwData["WBBBESCHICH"].ToString();
                    or1.Parameters.Add("WBBFARBE", OracleType.NVarChar).Value = dwData["WBBFARBE"].ToString();
                    break;
                case 2:
                    or1.CommandText = "SELECT * FROM WBBST WHERE WBBMANDANT=:WBBMANDANT "
                        + " AND WBBDISPOART=:WBBDISPOART "
                        + " AND WBBDISPOVAR=:WBBDISPOVAR "
                        + " AND WBBWAKZ=:WBBWAKZ "
                        + " AND WBBLO=:WBBLO "
                        + " AND WBBVERSANDKZ='N' "
                        + " AND WBBERLKZ <> 'J' "
                        + " AND WBBISTKLG > 0 "
                        // + " AND WBBLB=:WBBLB "                        
                        + " AND WBBDESS=:WBBDESS "
                        + " AND WBBCOLORIT=:WBBCOLORIT "
                        + " AND WBBBESCHICH=:WBBBESCHICH "
                        + " AND WBBFARBE=:WBBFARBE "
                        + " AND WBBAUFLFD='000000'"
                        + " ORDER BY WBBSSTKLG ASC";
                    or1.Parameters.Add("WBBMANDANT", OracleType.NVarChar).Value = dwData["WBBMANDANT"].ToString();
                    or1.Parameters.Add("WBBDISPOART", OracleType.NVarChar).Value = dwData["WBBDISPOART"].ToString();
                    or1.Parameters.Add("WBBDISPOVAR", OracleType.NVarChar).Value = dwData["WBBDISPOVAR"].ToString();
                    or1.Parameters.Add("WBBWAKZ", OracleType.NVarChar).Value = dwData["WBBWAKZ"].ToString();
                    or1.Parameters.Add("WBBLO", OracleType.NVarChar).Value = dwData["WBBLO"].ToString();
                    //or1.Parameters.Add("WBBLB", OracleType.NVarChar).Value = dwData["WBBLB"].ToString();
                    or1.Parameters.Add("WBBDESS", OracleType.NVarChar).Value = dwData["WBBDESS"].ToString();
                    or1.Parameters.Add("WBBCOLORIT", OracleType.NVarChar).Value = dwData["WBBCOLORIT"].ToString();
                    or1.Parameters.Add("WBBBESCHICH", OracleType.NVarChar).Value = dwData["WBBBESCHICH"].ToString();
                    or1.Parameters.Add("WBBFARBE", OracleType.NVarChar).Value = dwData["WBBFARBE"].ToString();
                    break;
                case 3:
                    //WBBAUFTYP	WBBAUFKRS	WBBAUFLFD	WBBAUFPOS
                    or1.CommandText = "SELECT  WBBPACKNR,WBBDPART2,WBBRWLFD,WBBPOS,WBBAUFKRS,WBBAUFLFD,WBBAUFPOS,WBBANZTEILE,WBBTP,WBBSTKNR,WBBISTKLG,WBBIGEW,WBBPACKTYP,WBBAUFMSL,WBBTAX,WBBDPART"
                    + " FROM WBBST WHERE WBBWAKZ=:WBBWAKZ AND WBBMANDANT=:WBBMANDANT "
                    + " AND WBBAUFTYP=:WBBAUFTYP "
                    + " AND WBBAUFKRS=:WBBAUFKRS "
                    + " AND WBBAUFLFD=:WBBAUFLFD "
                    + " AND WBBALIEFSCH='00000000'"
                    + " ORDER BY WBBPACKNR,WBBRWLFD,WBBPOS";
                    or1.Parameters.Add("WBBMANDANT", OracleType.NVarChar).Value = dwData["WBBMANDANT"].ToString();
                    or1.Parameters.Add("WBBWAKZ", OracleType.NVarChar).Value = dwData["WBBWAKZ"].ToString();                    
                    or1.Parameters.Add("WBBAUFTYP", OracleType.NVarChar).Value = dwData["WBBAUFTYP"].ToString();
                    or1.Parameters.Add("WBBAUFKRS", OracleType.NVarChar).Value = dwData["WBBAUFKRS"].ToString();
                    or1.Parameters.Add("WBBAUFLFD", OracleType.NVarChar).Value = dwData["WBBAUFLFD"].ToString();
                    break;
                case 4:
                    //WBBAUFTYP	WBBAUFKRS	WBBAUFLFD	WBBAUFPOS
                    or1.CommandText = "SELECT  WBBPACKNR,WBBART,WBBVAR,WBBFARBE,WBBRWLFD,WBBPOS,WBBAUFKRS,WBBAUFLFD,WBBAUFPOS,WBBANZTEILE,WBBSTKNR,WBBISTKLG,WBBIGEW,WBBPACKTYP,WBBAUFMSL,WBBALIEFSCH"
                    + " FROM WBBST WHERE WBBWAKZ='F' AND WBBMANDANT=:WBBMANDANT "
                    + " AND WBBALIEFSCH=:WBBALIEFSCH "
                    + " ORDER BY WBBRWLFD,WBBPOS";
                    or1.Parameters.Add("WBBMANDANT", OracleType.NVarChar).Value = dwData["WBBMANDANT"].ToString();
                    or1.Parameters.Add("WBBALIEFSCH", OracleType.NVarChar).Value = dwData["WBBALIEFSCH"].ToString();
                    break;
                case 5:
                    or1.CommandText = "SELECT * FROM WBBST WHERE WBBWAKZ='F' AND WBBMANDANT=:WBBMANDANT "
              + " AND WBBDISPOART=:WBBDISPOART "
              + " AND WBBDISPOVAR=:WBBDISPOVAR "
              + " AND WBBWAKZ=:WBBWAKZ "
              + " AND WBBLO=:WBBLO "
                        //              + " AND WBBLB=:WBBLB "
              + " AND WBBDESS=:WBBDESS "
              + " AND WBBCOLORIT=:WBBCOLORIT "
              + " AND WBBBESCHICH=:WBBBESCHICH "
              + " AND WBBFARBE=:WBBFARBE "
              + " AND WBBAUFLFD='000000'"
              + " AND WBBISTKLG-WBBTSTKLG>=0"
              + " ORDER BY WBBSSTKLG ASC";
                    or1.Parameters.Add("WBBMANDANT", OracleType.NVarChar).Value = dwData["WBBMANDANT"].ToString();
                    or1.Parameters.Add("WBBDISPOART", OracleType.NVarChar).Value = dwData["WBBDISPOART"].ToString();
                    or1.Parameters.Add("WBBDISPOVAR", OracleType.NVarChar).Value = dwData["WBBDISPOVAR"].ToString();
                    or1.Parameters.Add("WBBWAKZ", OracleType.NVarChar).Value = dwData["WBBWAKZ"].ToString();
                    or1.Parameters.Add("WBBLO", OracleType.NVarChar).Value = dwData["WBBLO"].ToString();
                    //or1.Parameters.Add("WBBLB", OracleType.NVarChar).Value = dwData["WBBLB"].ToString();
                    or1.Parameters.Add("WBBDESS", OracleType.NVarChar).Value = dwData["WBBDESS"].ToString();
                    or1.Parameters.Add("WBBCOLORIT", OracleType.NVarChar).Value = dwData["WBBCOLORIT"].ToString();
                    or1.Parameters.Add("WBBBESCHICH", OracleType.NVarChar).Value = dwData["WBBBESCHICH"].ToString();
                    or1.Parameters.Add("WBBFARBE", OracleType.NVarChar).Value = dwData["WBBFARBE"].ToString();
                    break;
                case 6:
                    or1.CommandText = "SELECT * FROM WBBST WHERE WBBWAKZ='F' AND WBBMANDANT=:WBBMANDANT "
                        + " AND WBBWAKZ=:WBBWAKZ "
                        + " AND WBBART=:WBBART "
                        + " AND WBBLO=:WBBLO "
                        + " AND WBBLB=:WBBLB "
                        + " AND WBBFARBE=:WBBFARBE "
                        + " AND WBBAUFLFD='000000'"
                        + " AND WBBISTKLG-WBBTSTKLG>=0"
                        + " ORDER BY WBBSTKNR ASC";
                    or1.Parameters.Add("WBBMANDANT", OracleType.NVarChar).Value = dwData["WBBMANDANT"].ToString();
                    or1.Parameters.Add("WBBWAKZ", OracleType.NVarChar).Value = dwData["WBBWAKZ"].ToString();
                    or1.Parameters.Add("WBBART", OracleType.NVarChar).Value = dwData["WBBART"].ToString();
                    or1.Parameters.Add("WBBFARBE", OracleType.NVarChar).Value = dwData["WBBFARBE"].ToString();
                    or1.Parameters.Add("WBBLO", OracleType.NVarChar).Value = dwData["WBBLO"].ToString();
                    or1.Parameters.Add("WBBLB", OracleType.NVarChar).Value = dwData["WBBLB"].ToString();
                    break;
                case 7:
                    //WBBAUFTYP	WBBAUFKRS	WBBAUFLFD	WBBAUFPOS
                    if (dwData["WBBFARBE"].ToString().Trim()== "")
                    {
                        or1.CommandText = "SELECT  WBBDPART2,WBBART,WBBFARBE, WBBPACKNR,WBBRWLFD,WBBPOS,WBBAUFKRS,WBBAUFLFD,WBBAUFPOS,WBBANZTEILE,WBBTP,WBBSTKNR,WBBISTKLG,WBBIGEW,WBBPACKTYP,WBBAUFMSL,WBBTAX,WBBDPART"
                        + " FROM WBBST WHERE WBBMANDANT=:WBBMANDANT AND WBBWAKZ=:WBBWAKZ"
                        + " AND WBBART=:WBBART"
                        + " AND WBBLO=:WBBLO"
                        + " AND WBBLB LIKE '" + dwData["WBBLB"].ToString().Trim() + "%'"
                        + " AND WBBALIEFSCH='00000000'"
                        + " ORDER BY WBBPACKNR, WBBRWLFD,WBBPOS";
                        or1.Parameters.Add("WBBMANDANT", OracleType.NVarChar).Value = dwData["WBBMANDANT"].ToString();
                        or1.Parameters.Add("WBBWAKZ", OracleType.NVarChar).Value = dwData["WBBWAKZ"].ToString(); 
                        or1.Parameters.Add("WBBART", OracleType.NVarChar).Value = dwData["WBBART"].ToString();
                        or1.Parameters.Add("WBBLO", OracleType.NVarChar).Value = dwData["WBBLO"].ToString();
                    }
                    else
                    {
                        or1.CommandText = "SELECT  WBBDPART2,WBBART,WBBFARBE,WBBPACKNR,WBBRWLFD,WBBPOS,WBBAUFKRS,WBBAUFLFD,WBBAUFPOS,WBBANZTEILE,WBBTP,WBBSTKNR,WBBISTKLG,WBBIGEW,WBBPACKTYP,WBBAUFMSL,WBBTAX,WBBDPART"
                       + " FROM WBBST WHERE WBBMANDANT=:WBBMANDANT "
                       + " AND WBBART=:WBBART"
                       + " AND WBBFARBE=:WBBFARBE"
                       + " AND WBBLO=:WBBLO"
                       + " AND WBBLB LIKE '" + dwData["WBBLB"].ToString().Trim() + "%'"
                       + " AND WBBALIEFSCH='00000000'"
                       + " ORDER BY WBBPACKNR, WBBRWLFD,WBBPOS";
                        or1.Parameters.Add("WBBMANDANT", OracleType.NVarChar).Value = dwData["WBBMANDANT"].ToString();
                        or1.Parameters.Add("WBBART", OracleType.NVarChar).Value = dwData["WBBART"].ToString();
                        or1.Parameters.Add("WBBFARBE", OracleType.NVarChar).Value = dwData["WBBFARBE"].ToString();                        
                        or1.Parameters.Add("WBBLO", OracleType.NVarChar).Value = dwData["WBBLO"].ToString();
                    }
                    break;
                case 8:
                    //WBBAUFTYP	WBBAUFKRS	WBBAUFLFD	WBBAUFPOS
                    or1.CommandText = "SELECT* "
                    + " FROM WBBST WHERE  WBBMANDANT=:WBBMANDANT "                    
                    + " AND WBBAUFKRS=:WBBAUFKRS "
                    + " AND WBBAUFLFD=:WBBAUFLFD "
                    + " AND WBBAUFPOS=:WBBAUFPOS " 
                    + " ORDER BY WBBRWLFD,WBBPOS";
                    or1.Parameters.Add("WBBMANDANT", OracleType.NVarChar).Value = dwData["WBBMANDANT"].ToString();
                    or1.Parameters.Add("WBBAUFKRS", OracleType.NVarChar).Value = dwData["WBBAUFKRS"].ToString();
                    or1.Parameters.Add("WBBAUFLFD", OracleType.NVarChar).Value = dwData["WBBAUFLFD"].ToString();
                    or1.Parameters.Add("WBBAUFPOS", OracleType.NVarChar).Value = dwData["WBBAUFPOS"].ToString(); 
                    break;
                default:
                    break;
            }

            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "WBBST";
            Return = Result;
            return Return;
        }
        public DataSet QueryWBBST(DataRow dwData)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT * FROM WBBST "
                + " WHERE WBBMANDANT=:WBBMANDANT and WBBRWKRS=:WBBRWKRS AND WBBRWLFD=:WBBRWLFD AND WBBPOS=:WBBPOS";
            or1.Parameters.Add("WBBMANDANT", OracleType.NVarChar).Value = dwData["WBBMANDANT"].ToString();
            or1.Parameters.Add("WBBRWKRS", OracleType.NVarChar).Value = dwData["WBBRWKRS"].ToString();
            or1.Parameters.Add("WBBRWLFD", OracleType.NVarChar).Value = dwData["WBBRWLFD"].ToString();
            or1.Parameters.Add("WBBPOS", OracleType.NVarChar).Value = dwData["WBBPOS"].ToString();
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "WBBST";
            Return = Result;
            return Return;
        }
        public void UpdateWBBST(DataRow dwData, int option = 1)
        {
            OracleCommand or1;
            DataSet result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command====
                    or1.CommandText = "UPDATE WBBST SET "
        + "WBBMANDANT=:WBBMANDANT,"
        + "WBBRWKRS=:WBBRWKRS,"
        + "WBBRWLFD=:WBBRWLFD,"
        + "WBBPOS=:WBBPOS,"
        + "WBBWERK=:WBBWERK,"
        + "WBBABT=:WBBABT,"
        + "WBBKUNDNR=:WBBKUNDNR,"
        + "WBBSTKNR=:WBBSTKNR,"
        + "WBBWAKZ=:WBBWAKZ,"
        + "WBBART=:WBBART,"
        + "WBBDESS=:WBBDESS,"
        + "WBBCOLORIT=:WBBCOLORIT,"
        + "WBBFARBE=:WBBFARBE,"
        + "WBBBESCHICH=:WBBBESCHICH,"
        + "WBBVAR=:WBBVAR,"
        + "WBBKOLL=:WBBKOLL,"
        + "WBBVKART=:WBBVKART,"
        + "WBBVKFARBE=:WBBVKFARBE,"
        + "WBBARTABW=:WBBARTABW,"
        + "WBBARTKUNDNR=:WBBARTKUNDNR,"
        + "WBBENTWKZ=:WBBENTWKZ,"
        + "WBBSSTKLG=:WBBSSTKLG,"
        + "WBBSGEW=:WBBSGEW,"
        + "WBBSBRT=:WBBSBRT,"
        + "WBBISTKLG=:WBBISTKLG,"
        + "WBBIGEW=:WBBIGEW,"
        + "WBBIBRT=:WBBIBRT,"
        + "WBBBRGEW=:WBBBRGEW,"
        + "WBBDM=:WBBDM,"
        + "WBBVOL=:WBBVOL,"
        + "WBBIGEWKZ=:WBBIGEWKZ,"
        + "WBBIANZ=:WBBIANZ,"
        + "WBBMABRT1=:WBBMABRT1,"
        + "WBBMASTKLG1=:WBBMASTKLG1,"
        + "WBBMABRT2=:WBBMABRT2,"
        + "WBBMASTKLG2=:WBBMASTKLG2,"
        + "WBBMABRT3=:WBBMABRT3,"
        + "WBBMASTKLG3=:WBBMASTKLG3,"
        + "WBBMABRT4=:WBBMABRT4,"
        + "WBBMASTKLG4=:WBBMASTKLG4,"
        + "WBBMABRT5=:WBBMABRT5,"
        + "WBBMASTKLG5=:WBBMASTKLG5,"
        + "WBBINDAT=:WBBINDAT,"
        + "WBBINBSTMTR=:WBBINBSTMTR,"
        + "WBBINBSTKG=:WBBINBSTKG,"
        + "WBBIPREIS=:WBBIPREIS,"
        + "WBBWARSCH=:WBBWARSCH,"
        + "WBBWDATUM=:WBBWDATUM,"
        + "WBBWSCHICHT=:WBBWSCHICHT,"
        + "WBBWMNRKRS=:WBBWMNRKRS,"
        + "WBBWMLFDNR=:WBBWMLFDNR,"
        + "WBBWMPOS=:WBBWMPOS,"
        + "WBBRE=:WBBRE,"
        + "WBBRENETTO=:WBBRENETTO,"
        + "WBBREVGUET=:WBBREVGUET,"
        + "WBBRS=:WBBRS,"
        + "WBBRSNETTO=:WBBRSNETTO,"
        + "WBBRSVGUET=:WBBRSVGUET,"
        + "WBBVE=:WBBVE,"
        + "WBBVENETTO=:WBBVENETTO,"
        + "WBBVEVGUET=:WBBVEVGUET,"
        + "WBBVS=:WBBVS,"
        + "WBBVSNETTO=:WBBVSNETTO,"
        + "WBBVSVGUET=:WBBVSVGUET,"
        + "WBBANZTEILE=:WBBANZTEILE,"
        + "WBBVERSION=:WBBVERSION,"
        + "WBBTAX=:WBBTAX,"
        + "WBBZENSUR=:WBBZENSUR,"
        + "WBBZENSURKZ=:WBBZENSURKZ,"
        + "WBBUBRT=:WBBUBRT,"
        + "WBBZAFOLGE=:WBBZAFOLGE,"
        + "WBBNAFOLGE=:WBBNAFOLGE,"
        + "WBBZLNR=:WBBZLNR,"
        + "WBBAUFMSL=:WBBAUFMSL,"
        + "WBBZUSAM=:WBBZUSAM,"
        + "WBBMAART=:WBBMAART,"
        + "WBBPACKTYP=:WBBPACKTYP,"
        + "WBBROLLR=:WBBROLLR,"
        + "WBBAUFMPOS=:WBBAUFMPOS,"
        + "WBBKONFKZ=:WBBKONFKZ,"
        + "WBBKETTELN=:WBBKETTELN,"
        + "WBBSHSTK1=:WBBSHSTK1,"
        + "WBBSHBRT1=:WBBSHBRT1,"
        + "WBBSHSTKLG1=:WBBSHSTKLG1,"
        + "WBBSHSTK2=:WBBSHSTK2,"
        + "WBBSHBRT2=:WBBSHBRT2,"
        + "WBBSHSTKLG2=:WBBSHSTKLG2,"
        + "WBBSHSTK3=:WBBSHSTK3,"
        + "WBBSHBRT3=:WBBSHBRT3,"
        + "WBBSHSTKLG3=:WBBSHSTKLG3,"
        + "WBBSHSTK4=:WBBSHSTK4,"
        + "WBBSHBRT4=:WBBSHBRT4,"
        + "WBBSHSTKLG4=:WBBSHSTKLG4,"
        + "WBBSHSTK5=:WBBSHSTK5,"
        + "WBBSHBRT5=:WBBSHBRT5,"
        + "WBBSHSTKLG5=:WBBSHSTKLG5,"
        + "WBBSTKNRK=:WBBSTKNRK,"
        + "WBBLO=:WBBLO,"
        + "WBBLB=:WBBLB,"
        + "WBBKZ=:WBBKZ,"
        + "WBBLP=:WBBLP,"
        + "WBBAUFBKZ=:WBBAUFBKZ,"
        + "WBBGEBNR=:WBBGEBNR,"
        + "WBBGEBPOS=:WBBGEBPOS,"
        + "WBBSPSTA=:WBBSPSTA,"
        + "WBBSPGRD=:WBBSPGRD,"
        + "WBBERLKZ=:WBBERLKZ,"
        + "WBBAUFTYP=:WBBAUFTYP,"
        + "WBBAUFKRS=:WBBAUFKRS,"
        + "WBBAUFLFD=:WBBAUFLFD,"
        + "WBBAUFPOS=:WBBAUFPOS,"
        + "WBBTP=:WBBTP,"
        + "WBBFOLGE=:WBBFOLGE,"
        + "WBBAFOLGEVON=:WBBAFOLGEVON,"
        + "WBBRAFOLGE=:WBBRAFOLGE,"
        + "WBBMAFOLGE=:WBBMAFOLGE,"
        + "WBBRSTKLG=:WBBRSTKLG,"
        + "WBBRGEW=:WBBRGEW,"
        + "WBBLGAE=:WBBLGAE,"
        + "WBBGEWAE=:WBBGEWAE,"
        + "WBBPOOL=:WBBPOOL,"
        + "WBBAUTZU=:WBBAUTZU,"
        + "WBBWDUPOS=:WBBWDUPOS,"
        + "WBBRBENID=:WBBRBENID,"
        + "WBBRDATB=:WBBRDATB,"
        + "WBBRDAT=:WBBRDAT,"
        + "WBBRBEM=:WBBRBEM,"
        + "WBBRKUNDNR=:WBBRKUNDNR,"
        + "WBBDPART=:WBBDPART,"
        + "WBBDPART2=:WBBDPART2,"
        + "WBBZUSTAND=:WBBZUSTAND,"
        + "WBBFARBN=:WBBFARBN,"
        + "WBBSPKZ=:WBBSPKZ,"
        + "WBBCUKZ=:WBBCUKZ,"
        + "WBBDISPOART=:WBBDISPOART,"
        + "WBBDISPOVAR=:WBBDISPOVAR,"
        + "WBBAUSFFRB=:WBBAUSFFRB,"
        + "WBBAUSFGRI=:WBBAUSFGRI,"
        + "WBBAUSFQUAL=:WBBAUSFQUAL,"
        + "WBBQUALST=:WBBQUALST,"
        + "WBBQPKT=:WBBQPKT,"
        + "WBBQPKTH=:WBBQPKTH,"
        + "WBBQPKTL=:WBBQPKTL,"
        + "WBBQPKTLH=:WBBQPKTLH,"
        + "WBBVB=:WBBVB,"
        + "WBBVG=:WBBVG,"
        + "WBBVLVB=:WBBVLVB,"
        + "WBBVLVG=:WBBVLVG,"
        + "WBBVLSACHB=:WBBVLSACHB,"
        + "WBBVLGEGEN=:WBBVLGEGEN,"
        + "WBBPRKUNDNR=:WBBPRKUNDNR,"
        + "WBBGENNR=:WBBGENNR,"
        + "WBBELOA=:WBBELOA,"
        + "WBBELOB=:WBBELOB,"
        + "WBBURAUFKRS=:WBBURAUFKRS,"
        + "WBBURAUFLFD=:WBBURAUFLFD,"
        + "WBBURAUFPOS=:WBBURAUFPOS,"
        + "WBBVKNPOS=:WBBVKNPOS,"
        + "WBBURLAND=:WBBURLAND,"
        + "WBBVERZKZ=:WBBVERZKZ,"
        + "WBBTSTKLG=:WBBTSTKLG,"
        + "WBBTANZ=:WBBTANZ,"
        + "WBBURPOS=:WBBURPOS,"
        + "WBBTEILPOS=:WBBTEILPOS,"
        + "WBBECKZ=:WBBECKZ,"
        + "WBBTLGAFOLGE=:WBBTLGAFOLGE,"
        + "WBBZMT=:WBBZMT,"
        + "WBBANZSNT=:WBBANZSNT,"
        + "WBBTLBRT=:WBBTLBRT,"
        + "WBBTLSTKLG=:WBBTLSTKLG,"
        + "WBBTLRICHT=:WBBTLRICHT,"
        + "WBBDRKZ1=:WBBDRKZ1,"
        + "WBBDRKZ2=:WBBDRKZ2,"
        + "WBBEINDAT=:WBBEINDAT,"
        + "WBBWSTKLG=:WBBWSTKLG,"
        + "WBBWBRT=:WBBWBRT,"
        + "WBBWBMNRKRS=:WBBWBMNRKRS,"
        + "WBBWBMLFDNR=:WBBWBMLFDNR,"
        + "WBBWBMPOS=:WBBWBMPOS,"
        + "WBBSCHUSS=:WBBSCHUSS,"
        + "WBBWERKE=:WBBWERKE,"
        + "WBBLIEF=:WBBLIEF,"
        + "WBBBAHN=:WBBBAHN,"
        + "WBBBAHNMAX=:WBBBAHNMAX,"
        + "WBBWLO=:WBBWLO,"
        + "WBBWLB=:WBBWLB,"
        + "WBBWLP=:WBBWLP,"
        + "WBBWAUFBKZ=:WBBWAUFBKZ,"
        + "WBBKANTE=:WBBKANTE,"
        + "WBBSOLLKZ=:WBBSOLLKZ,"
        + "WBBMATAB=:WBBMATAB,"
        + "WBBWJJJJ=:WBBWJJJJ,"
        + "WBBWBNR=:WBBWBNR,"
        + "WBBFLZZUGDAT=:WBBFLZZUGDAT,"
        + "WBBISTKLGFA=:WBBISTKLGFA,"
        + "WBBISTKLGF=:WBBISTKLGF,"
        + "WBBFRTWSKZ=:WBBFRTWSKZ,"
        + "WBBLTPOS=:WBBLTPOS,"
        + "WBBILGFBT=:WBBILGFBT,"
        + "WBBILGRBT=:WBBILGRBT,"
        + "WBBIBRTFV=:WBBIBRTFV,"
        + "WBBIBRTFB=:WBBIBRTFB,"
        + "WBBFEUCHTE=:WBBFEUCHTE,"
        + "WBBLIEFSCH=:WBBLIEFSCH,"
        + "WBBKDPART=:WBBKDPART,"
        + "WBBSCHLICHTEKZ=:WBBSCHLICHTEKZ,"
        + "WBBASWAKZ=:WBBASWAKZ,"
        + "WBBASART=:WBBASART,"
        + "WBBASVAR=:WBBASVAR,"
        + "WBBFARBEALT=:WBBFARBEALT,"
        + "WBBCOLALT=:WBBCOLALT,"
        + "WBBDESSALT=:WBBDESSALT,"
        + "WBBBESALT=:WBBBESALT,"
        + "WBBZUSTANDA=:WBBZUSTANDA,"
        + "WBBMASSKZ=:WBBMASSKZ,"
        + "WBBFJJJJ=:WBBFJJJJ,"
        + "WBBFBNR=:WBBFBNR,"
        + "WBBRETOURKZ=:WBBRETOURKZ,"
        + "WBBREAUFKRS=:WBBREAUFKRS,"
        + "WBBREAUFLFD=:WBBREAUFLFD,"
        + "WBBREAUFPOS=:WBBREAUFPOS,"
        + "WBBREAFOLGE=:WBBREAFOLGE,"
        + "WBBTPA=:WBBTPA,"
        + "WBBKOMMNR=:WBBKOMMNR,"
        + "WBBALIEFSCH=:WBBALIEFSCH,"
        + "WBBPACKNR=:WBBPACKNR,"
        + "WBBPACKAUTO=:WBBPACKAUTO,"
        + "WBBRUEKZ=:WBBRUEKZ,"
        + "WBBURLB=:WBBURLB,"
        + "WBBURLP=:WBBURLP,"
        + "WBBURAKZ=:WBBURAKZ,"
        + "WBBVERSDAT=:WBBVERSDAT,"
        + "WBBVERSANDKZ=:WBBVERSANDKZ,"
        + "WBBURLIEFSCH=:WBBURLIEFSCH,"
        + "WBBARECHNR=:WBBARECHNR,"
        + "WBBFERTKZ=:WBBFERTKZ,"
        + "WBBEGKZ=:WBBEGKZ,"
        + "WBBBEM=:WBBBEM,"
        + "WBBTXSCHL=:WBBTXSCHL,"
        + "WBBHHK1=:WBBHHK1,"
        + "WBBHHK2=:WBBHHK2,"
        + "WBBHHK3=:WBBHHK3,"
        + "WBBHHK4=:WBBHHK4,"
        + "WBBHHK5=:WBBHHK5,"
        + "WBBHHK6=:WBBHHK6,"
        + "WBBHHK7=:WBBHHK7,"
        + "WBBHHK8=:WBBHHK8,"
        + "WBBHHK9=:WBBHHK9,"
        + "WBBHHK10=:WBBHHK10,"
        + "WBBHHKG=:WBBHHKG,"
        + "WBBAHK1=:WBBAHK1,"
        + "WBBAHK2=:WBBAHK2,"
        + "WBBAHK3=:WBBAHK3,"
        + "WBBAHK4=:WBBAHK4,"
        + "WBBAHK5=:WBBAHK5,"
        + "WBBAHK6=:WBBAHK6,"
        + "WBBAHK7=:WBBAHK7,"
        + "WBBAHK8=:WBBAHK8,"
        + "WBBAHK9=:WBBAHK9,"
        + "WBBAHK10=:WBBAHK10,"
        + "WBBAHKG=:WBBAHKG,"
        + "WBBABPZAB=:WBBABPZAB,"
        + "WBBABDATAB=:WBBABDATAB,"
        + "WBBNEUBEN=:WBBNEUBEN,"
        + "WBBNEUDAT=:WBBNEUDAT,"
        + "WBBAENDBEN=:WBBAENDBEN,"
        + "WBBAENDDAT=:WBBAENDDAT,"
        + "WBBAENDZL=:WBBAENDZL,"
        + "WBBWS=:WBBWS,"
        + "WBBWSNO=:WBBWSNO,"
        + "WBBFILLER=:WBBFILLER "
        + " WHERE  "
                       + "  WBBMANDANT=:WBBMANDANT AND WBBRWKRS=:WBBRWKRS AND WBBRWLFD=:WBBRWLFD AND WBBPOS=:WBBPOS";
                    #endregion

                    #region====Parameters====
                    or1.Parameters.Add("WBBMANDANT", OracleType.NVarChar).Value = dwData["WBBMANDANT"].ToString();
                    or1.Parameters.Add("WBBRWKRS", OracleType.NVarChar).Value = dwData["WBBRWKRS"].ToString();
                    or1.Parameters.Add("WBBRWLFD", OracleType.NVarChar).Value = dwData["WBBRWLFD"].ToString();
                    or1.Parameters.Add("WBBPOS", OracleType.NVarChar).Value = dwData["WBBPOS"].ToString();
                    or1.Parameters.Add("WBBWERK", OracleType.NVarChar).Value = dwData["WBBWERK"].ToString();
                    or1.Parameters.Add("WBBABT", OracleType.NVarChar).Value = dwData["WBBABT"].ToString();
                    or1.Parameters.Add("WBBKUNDNR", OracleType.NVarChar).Value = dwData["WBBKUNDNR"].ToString();
                    or1.Parameters.Add("WBBSTKNR", OracleType.NVarChar).Value = dwData["WBBSTKNR"].ToString();
                    or1.Parameters.Add("WBBWAKZ", OracleType.NVarChar).Value = dwData["WBBWAKZ"].ToString();
                    or1.Parameters.Add("WBBART", OracleType.NVarChar).Value = dwData["WBBART"].ToString();
                    or1.Parameters.Add("WBBDESS", OracleType.NVarChar).Value = dwData["WBBDESS"].ToString();
                    or1.Parameters.Add("WBBCOLORIT", OracleType.NVarChar).Value = dwData["WBBCOLORIT"].ToString();
                    or1.Parameters.Add("WBBFARBE", OracleType.NVarChar).Value = dwData["WBBFARBE"].ToString();
                    or1.Parameters.Add("WBBBESCHICH", OracleType.NVarChar).Value = dwData["WBBBESCHICH"].ToString();
                    or1.Parameters.Add("WBBVAR", OracleType.NVarChar).Value = dwData["WBBVAR"].ToString();
                    or1.Parameters.Add("WBBKOLL", OracleType.NVarChar).Value = dwData["WBBKOLL"].ToString();
                    or1.Parameters.Add("WBBVKART", OracleType.NVarChar).Value = dwData["WBBVKART"].ToString();
                    or1.Parameters.Add("WBBVKFARBE", OracleType.NVarChar).Value = dwData["WBBVKFARBE"].ToString();
                    or1.Parameters.Add("WBBARTABW", OracleType.NVarChar).Value = dwData["WBBARTABW"].ToString();
                    or1.Parameters.Add("WBBARTKUNDNR", OracleType.NVarChar).Value = dwData["WBBARTKUNDNR"].ToString();
                    or1.Parameters.Add("WBBENTWKZ", OracleType.NVarChar).Value = dwData["WBBENTWKZ"].ToString();
                    or1.Parameters.Add("WBBSSTKLG", OracleType.NVarChar).Value = dwData["WBBSSTKLG"].ToString();
                    or1.Parameters.Add("WBBSGEW", OracleType.NVarChar).Value = dwData["WBBSGEW"].ToString();
                    or1.Parameters.Add("WBBSBRT", OracleType.NVarChar).Value = dwData["WBBSBRT"].ToString();
                    or1.Parameters.Add("WBBISTKLG", OracleType.NVarChar).Value = dwData["WBBISTKLG"].ToString();
                    or1.Parameters.Add("WBBIGEW", OracleType.NVarChar).Value = dwData["WBBIGEW"].ToString();
                    or1.Parameters.Add("WBBIBRT", OracleType.NVarChar).Value = dwData["WBBIBRT"].ToString();
                    or1.Parameters.Add("WBBBRGEW", OracleType.NVarChar).Value = dwData["WBBBRGEW"].ToString();
                    or1.Parameters.Add("WBBDM", OracleType.NVarChar).Value = dwData["WBBDM"].ToString();
                    or1.Parameters.Add("WBBVOL", OracleType.NVarChar).Value = dwData["WBBVOL"].ToString();
                    or1.Parameters.Add("WBBIGEWKZ", OracleType.NVarChar).Value = dwData["WBBIGEWKZ"].ToString();
                    or1.Parameters.Add("WBBIANZ", OracleType.NVarChar).Value = dwData["WBBIANZ"].ToString();
                    or1.Parameters.Add("WBBMABRT1", OracleType.NVarChar).Value = dwData["WBBMABRT1"].ToString();
                    or1.Parameters.Add("WBBMASTKLG1", OracleType.NVarChar).Value = dwData["WBBMASTKLG1"].ToString();
                    or1.Parameters.Add("WBBMABRT2", OracleType.NVarChar).Value = dwData["WBBMABRT2"].ToString();
                    or1.Parameters.Add("WBBMASTKLG2", OracleType.NVarChar).Value = dwData["WBBMASTKLG2"].ToString();
                    or1.Parameters.Add("WBBMABRT3", OracleType.NVarChar).Value = dwData["WBBMABRT3"].ToString();
                    or1.Parameters.Add("WBBMASTKLG3", OracleType.NVarChar).Value = dwData["WBBMASTKLG3"].ToString();
                    or1.Parameters.Add("WBBMABRT4", OracleType.NVarChar).Value = dwData["WBBMABRT4"].ToString();
                    or1.Parameters.Add("WBBMASTKLG4", OracleType.NVarChar).Value = dwData["WBBMASTKLG4"].ToString();
                    or1.Parameters.Add("WBBMABRT5", OracleType.NVarChar).Value = dwData["WBBMABRT5"].ToString();
                    or1.Parameters.Add("WBBMASTKLG5", OracleType.NVarChar).Value = dwData["WBBMASTKLG5"].ToString();
                    or1.Parameters.Add("WBBINDAT", OracleType.NVarChar).Value = dwData["WBBINDAT"].ToString();
                    or1.Parameters.Add("WBBINBSTMTR", OracleType.NVarChar).Value = dwData["WBBINBSTMTR"].ToString();
                    or1.Parameters.Add("WBBINBSTKG", OracleType.NVarChar).Value = dwData["WBBINBSTKG"].ToString();
                    or1.Parameters.Add("WBBIPREIS", OracleType.NVarChar).Value = dwData["WBBIPREIS"].ToString();
                    or1.Parameters.Add("WBBWARSCH", OracleType.NVarChar).Value = dwData["WBBWARSCH"].ToString();
                    or1.Parameters.Add("WBBWDATUM", OracleType.NVarChar).Value = dwData["WBBWDATUM"].ToString();
                    or1.Parameters.Add("WBBWSCHICHT", OracleType.NVarChar).Value = dwData["WBBWSCHICHT"].ToString();
                    or1.Parameters.Add("WBBWMNRKRS", OracleType.NVarChar).Value = dwData["WBBWMNRKRS"].ToString();
                    or1.Parameters.Add("WBBWMLFDNR", OracleType.NVarChar).Value = dwData["WBBWMLFDNR"].ToString();
                    or1.Parameters.Add("WBBWMPOS", OracleType.NVarChar).Value = dwData["WBBWMPOS"].ToString();
                    or1.Parameters.Add("WBBRE", OracleType.NVarChar).Value = dwData["WBBRE"].ToString();
                    or1.Parameters.Add("WBBRENETTO", OracleType.NVarChar).Value = dwData["WBBRENETTO"].ToString();
                    or1.Parameters.Add("WBBREVGUET", OracleType.NVarChar).Value = dwData["WBBREVGUET"].ToString();
                    or1.Parameters.Add("WBBRS", OracleType.NVarChar).Value = dwData["WBBRS"].ToString();
                    or1.Parameters.Add("WBBRSNETTO", OracleType.NVarChar).Value = dwData["WBBRSNETTO"].ToString();
                    or1.Parameters.Add("WBBRSVGUET", OracleType.NVarChar).Value = dwData["WBBRSVGUET"].ToString();
                    or1.Parameters.Add("WBBVE", OracleType.NVarChar).Value = dwData["WBBVE"].ToString();
                    or1.Parameters.Add("WBBVENETTO", OracleType.NVarChar).Value = dwData["WBBVENETTO"].ToString();
                    or1.Parameters.Add("WBBVEVGUET", OracleType.NVarChar).Value = dwData["WBBVEVGUET"].ToString();
                    or1.Parameters.Add("WBBVS", OracleType.NVarChar).Value = dwData["WBBVS"].ToString();
                    or1.Parameters.Add("WBBVSNETTO", OracleType.NVarChar).Value = dwData["WBBVSNETTO"].ToString();
                    or1.Parameters.Add("WBBVSVGUET", OracleType.NVarChar).Value = dwData["WBBVSVGUET"].ToString();
                    or1.Parameters.Add("WBBANZTEILE", OracleType.NVarChar).Value = dwData["WBBANZTEILE"].ToString();
                    or1.Parameters.Add("WBBVERSION", OracleType.NVarChar).Value = dwData["WBBVERSION"].ToString();
                    or1.Parameters.Add("WBBTAX", OracleType.NVarChar).Value = dwData["WBBTAX"].ToString();
                    or1.Parameters.Add("WBBZENSUR", OracleType.NVarChar).Value = dwData["WBBZENSUR"].ToString();
                    or1.Parameters.Add("WBBZENSURKZ", OracleType.NVarChar).Value = dwData["WBBZENSURKZ"].ToString();
                    or1.Parameters.Add("WBBUBRT", OracleType.NVarChar).Value = dwData["WBBUBRT"].ToString();
                    or1.Parameters.Add("WBBZAFOLGE", OracleType.NVarChar).Value = dwData["WBBZAFOLGE"].ToString();
                    or1.Parameters.Add("WBBNAFOLGE", OracleType.NVarChar).Value = dwData["WBBNAFOLGE"].ToString();
                    or1.Parameters.Add("WBBZLNR", OracleType.NVarChar).Value = dwData["WBBZLNR"].ToString();
                    or1.Parameters.Add("WBBAUFMSL", OracleType.NVarChar).Value = dwData["WBBAUFMSL"].ToString();
                    or1.Parameters.Add("WBBZUSAM", OracleType.NVarChar).Value = dwData["WBBZUSAM"].ToString();
                    or1.Parameters.Add("WBBMAART", OracleType.NVarChar).Value = dwData["WBBMAART"].ToString();
                    or1.Parameters.Add("WBBPACKTYP", OracleType.NVarChar).Value = dwData["WBBPACKTYP"].ToString();
                    or1.Parameters.Add("WBBROLLR", OracleType.NVarChar).Value = dwData["WBBROLLR"].ToString();
                    or1.Parameters.Add("WBBAUFMPOS", OracleType.NVarChar).Value = dwData["WBBAUFMPOS"].ToString();
                    or1.Parameters.Add("WBBKONFKZ", OracleType.NVarChar).Value = dwData["WBBKONFKZ"].ToString();
                    or1.Parameters.Add("WBBKETTELN", OracleType.NVarChar).Value = dwData["WBBKETTELN"].ToString();
                    or1.Parameters.Add("WBBSHSTK1", OracleType.NVarChar).Value = dwData["WBBSHSTK1"].ToString();
                    or1.Parameters.Add("WBBSHBRT1", OracleType.NVarChar).Value = dwData["WBBSHBRT1"].ToString();
                    or1.Parameters.Add("WBBSHSTKLG1", OracleType.NVarChar).Value = dwData["WBBSHSTKLG1"].ToString();
                    or1.Parameters.Add("WBBSHSTK2", OracleType.NVarChar).Value = dwData["WBBSHSTK2"].ToString();
                    or1.Parameters.Add("WBBSHBRT2", OracleType.NVarChar).Value = dwData["WBBSHBRT2"].ToString();
                    or1.Parameters.Add("WBBSHSTKLG2", OracleType.NVarChar).Value = dwData["WBBSHSTKLG2"].ToString();
                    or1.Parameters.Add("WBBSHSTK3", OracleType.NVarChar).Value = dwData["WBBSHSTK3"].ToString();
                    or1.Parameters.Add("WBBSHBRT3", OracleType.NVarChar).Value = dwData["WBBSHBRT3"].ToString();
                    or1.Parameters.Add("WBBSHSTKLG3", OracleType.NVarChar).Value = dwData["WBBSHSTKLG3"].ToString();
                    or1.Parameters.Add("WBBSHSTK4", OracleType.NVarChar).Value = dwData["WBBSHSTK4"].ToString();
                    or1.Parameters.Add("WBBSHBRT4", OracleType.NVarChar).Value = dwData["WBBSHBRT4"].ToString();
                    or1.Parameters.Add("WBBSHSTKLG4", OracleType.NVarChar).Value = dwData["WBBSHSTKLG4"].ToString();
                    or1.Parameters.Add("WBBSHSTK5", OracleType.NVarChar).Value = dwData["WBBSHSTK5"].ToString();
                    or1.Parameters.Add("WBBSHBRT5", OracleType.NVarChar).Value = dwData["WBBSHBRT5"].ToString();
                    or1.Parameters.Add("WBBSHSTKLG5", OracleType.NVarChar).Value = dwData["WBBSHSTKLG5"].ToString();
                    or1.Parameters.Add("WBBSTKNRK", OracleType.NVarChar).Value = dwData["WBBSTKNRK"].ToString();
                    or1.Parameters.Add("WBBLO", OracleType.NVarChar).Value = dwData["WBBLO"].ToString();
                    or1.Parameters.Add("WBBLB", OracleType.NVarChar).Value = dwData["WBBLB"].ToString();
                    or1.Parameters.Add("WBBKZ", OracleType.NVarChar).Value = dwData["WBBKZ"].ToString();
                    or1.Parameters.Add("WBBLP", OracleType.NVarChar).Value = dwData["WBBLP"].ToString();
                    or1.Parameters.Add("WBBAUFBKZ", OracleType.NVarChar).Value = dwData["WBBAUFBKZ"].ToString();
                    or1.Parameters.Add("WBBGEBNR", OracleType.NVarChar).Value = dwData["WBBGEBNR"].ToString();
                    or1.Parameters.Add("WBBGEBPOS", OracleType.NVarChar).Value = dwData["WBBGEBPOS"].ToString();
                    or1.Parameters.Add("WBBSPSTA", OracleType.NVarChar).Value = dwData["WBBSPSTA"].ToString();
                    or1.Parameters.Add("WBBSPGRD", OracleType.NVarChar).Value = dwData["WBBSPGRD"].ToString();
                    or1.Parameters.Add("WBBERLKZ", OracleType.NVarChar).Value = dwData["WBBERLKZ"].ToString();
                    or1.Parameters.Add("WBBAUFTYP", OracleType.NVarChar).Value = dwData["WBBAUFTYP"].ToString();
                    or1.Parameters.Add("WBBAUFKRS", OracleType.NVarChar).Value = dwData["WBBAUFKRS"].ToString();
                    or1.Parameters.Add("WBBAUFLFD", OracleType.NVarChar).Value = dwData["WBBAUFLFD"].ToString();
                    or1.Parameters.Add("WBBAUFPOS", OracleType.NVarChar).Value = dwData["WBBAUFPOS"].ToString();
                    or1.Parameters.Add("WBBTP", OracleType.NVarChar).Value = dwData["WBBTP"].ToString();
                    or1.Parameters.Add("WBBFOLGE", OracleType.NVarChar).Value = dwData["WBBFOLGE"].ToString();
                    or1.Parameters.Add("WBBAFOLGEVON", OracleType.NVarChar).Value = dwData["WBBAFOLGEVON"].ToString();
                    or1.Parameters.Add("WBBRAFOLGE", OracleType.NVarChar).Value = dwData["WBBRAFOLGE"].ToString();
                    or1.Parameters.Add("WBBMAFOLGE", OracleType.NVarChar).Value = dwData["WBBMAFOLGE"].ToString();
                    or1.Parameters.Add("WBBRSTKLG", OracleType.NVarChar).Value = dwData["WBBRSTKLG"].ToString();
                    or1.Parameters.Add("WBBRGEW", OracleType.NVarChar).Value = dwData["WBBRGEW"].ToString();
                    or1.Parameters.Add("WBBLGAE", OracleType.NVarChar).Value = dwData["WBBLGAE"].ToString();
                    or1.Parameters.Add("WBBGEWAE", OracleType.NVarChar).Value = dwData["WBBGEWAE"].ToString();
                    or1.Parameters.Add("WBBPOOL", OracleType.NVarChar).Value = dwData["WBBPOOL"].ToString();
                    or1.Parameters.Add("WBBAUTZU", OracleType.NVarChar).Value = dwData["WBBAUTZU"].ToString();
                    or1.Parameters.Add("WBBWDUPOS", OracleType.NVarChar).Value = dwData["WBBWDUPOS"].ToString();
                    or1.Parameters.Add("WBBRBENID", OracleType.NVarChar).Value = dwData["WBBRBENID"].ToString();
                    or1.Parameters.Add("WBBRDATB", OracleType.NVarChar).Value = dwData["WBBRDATB"].ToString();
                    or1.Parameters.Add("WBBRDAT", OracleType.NVarChar).Value = dwData["WBBRDAT"].ToString();
                    or1.Parameters.Add("WBBRBEM", OracleType.NVarChar).Value = dwData["WBBRBEM"].ToString();
                    or1.Parameters.Add("WBBRKUNDNR", OracleType.NVarChar).Value = dwData["WBBRKUNDNR"].ToString();
                    or1.Parameters.Add("WBBDPART", OracleType.NVarChar).Value = dwData["WBBDPART"].ToString();
                    or1.Parameters.Add("WBBDPART2", OracleType.NVarChar).Value = dwData["WBBDPART2"].ToString();
                    or1.Parameters.Add("WBBZUSTAND", OracleType.NVarChar).Value = dwData["WBBZUSTAND"].ToString();
                    or1.Parameters.Add("WBBFARBN", OracleType.NVarChar).Value = dwData["WBBFARBN"].ToString();
                    or1.Parameters.Add("WBBSPKZ", OracleType.NVarChar).Value = dwData["WBBSPKZ"].ToString();
                    or1.Parameters.Add("WBBCUKZ", OracleType.NVarChar).Value = dwData["WBBCUKZ"].ToString();
                    or1.Parameters.Add("WBBDISPOART", OracleType.NVarChar).Value = dwData["WBBDISPOART"].ToString();
                    or1.Parameters.Add("WBBDISPOVAR", OracleType.NVarChar).Value = dwData["WBBDISPOVAR"].ToString();
                    or1.Parameters.Add("WBBAUSFFRB", OracleType.NVarChar).Value = dwData["WBBAUSFFRB"].ToString();
                    or1.Parameters.Add("WBBAUSFGRI", OracleType.NVarChar).Value = dwData["WBBAUSFGRI"].ToString();
                    or1.Parameters.Add("WBBAUSFQUAL", OracleType.NVarChar).Value = dwData["WBBAUSFQUAL"].ToString();
                    or1.Parameters.Add("WBBQUALST", OracleType.NVarChar).Value = dwData["WBBQUALST"].ToString();
                    or1.Parameters.Add("WBBQPKT", OracleType.NVarChar).Value = dwData["WBBQPKT"].ToString();
                    or1.Parameters.Add("WBBQPKTH", OracleType.NVarChar).Value = dwData["WBBQPKTH"].ToString();
                    or1.Parameters.Add("WBBQPKTL", OracleType.NVarChar).Value = dwData["WBBQPKTL"].ToString();
                    or1.Parameters.Add("WBBQPKTLH", OracleType.NVarChar).Value = dwData["WBBQPKTLH"].ToString();
                    or1.Parameters.Add("WBBVB", OracleType.NVarChar).Value = dwData["WBBVB"].ToString();
                    or1.Parameters.Add("WBBVG", OracleType.NVarChar).Value = dwData["WBBVG"].ToString();
                    or1.Parameters.Add("WBBVLVB", OracleType.NVarChar).Value = dwData["WBBVLVB"].ToString();
                    or1.Parameters.Add("WBBVLVG", OracleType.NVarChar).Value = dwData["WBBVLVG"].ToString();
                    or1.Parameters.Add("WBBVLSACHB", OracleType.NVarChar).Value = dwData["WBBVLSACHB"].ToString();
                    or1.Parameters.Add("WBBVLGEGEN", OracleType.NVarChar).Value = dwData["WBBVLGEGEN"].ToString();
                    or1.Parameters.Add("WBBPRKUNDNR", OracleType.NVarChar).Value = dwData["WBBPRKUNDNR"].ToString();
                    or1.Parameters.Add("WBBGENNR", OracleType.NVarChar).Value = dwData["WBBGENNR"].ToString();
                    or1.Parameters.Add("WBBELOA", OracleType.NVarChar).Value = dwData["WBBELOA"].ToString();
                    or1.Parameters.Add("WBBELOB", OracleType.NVarChar).Value = dwData["WBBELOB"].ToString();
                    or1.Parameters.Add("WBBURAUFKRS", OracleType.NVarChar).Value = dwData["WBBURAUFKRS"].ToString();
                    or1.Parameters.Add("WBBURAUFLFD", OracleType.NVarChar).Value = dwData["WBBURAUFLFD"].ToString();
                    or1.Parameters.Add("WBBURAUFPOS", OracleType.NVarChar).Value = dwData["WBBURAUFPOS"].ToString();
                    or1.Parameters.Add("WBBVKNPOS", OracleType.NVarChar).Value = dwData["WBBVKNPOS"].ToString();
                    or1.Parameters.Add("WBBURLAND", OracleType.NVarChar).Value = dwData["WBBURLAND"].ToString();
                    or1.Parameters.Add("WBBVERZKZ", OracleType.NVarChar).Value = dwData["WBBVERZKZ"].ToString();
                    or1.Parameters.Add("WBBTSTKLG", OracleType.NVarChar).Value = dwData["WBBTSTKLG"].ToString();
                    or1.Parameters.Add("WBBTANZ", OracleType.NVarChar).Value = dwData["WBBTANZ"].ToString();
                    or1.Parameters.Add("WBBURPOS", OracleType.NVarChar).Value = dwData["WBBURPOS"].ToString();
                    or1.Parameters.Add("WBBTEILPOS", OracleType.NVarChar).Value = dwData["WBBTEILPOS"].ToString();
                    or1.Parameters.Add("WBBECKZ", OracleType.NVarChar).Value = dwData["WBBECKZ"].ToString();
                    or1.Parameters.Add("WBBTLGAFOLGE", OracleType.NVarChar).Value = dwData["WBBTLGAFOLGE"].ToString();
                    or1.Parameters.Add("WBBZMT", OracleType.NVarChar).Value = dwData["WBBZMT"].ToString();
                    or1.Parameters.Add("WBBANZSNT", OracleType.NVarChar).Value = dwData["WBBANZSNT"].ToString();
                    or1.Parameters.Add("WBBTLBRT", OracleType.NVarChar).Value = dwData["WBBTLBRT"].ToString();
                    or1.Parameters.Add("WBBTLSTKLG", OracleType.NVarChar).Value = dwData["WBBTLSTKLG"].ToString();
                    or1.Parameters.Add("WBBTLRICHT", OracleType.NVarChar).Value = dwData["WBBTLRICHT"].ToString();
                    or1.Parameters.Add("WBBDRKZ1", OracleType.NVarChar).Value = dwData["WBBDRKZ1"].ToString();
                    or1.Parameters.Add("WBBDRKZ2", OracleType.NVarChar).Value = dwData["WBBDRKZ2"].ToString();
                    or1.Parameters.Add("WBBEINDAT", OracleType.NVarChar).Value = dwData["WBBEINDAT"].ToString();
                    or1.Parameters.Add("WBBWSTKLG", OracleType.NVarChar).Value = dwData["WBBWSTKLG"].ToString();
                    or1.Parameters.Add("WBBWBRT", OracleType.NVarChar).Value = dwData["WBBWBRT"].ToString();
                    or1.Parameters.Add("WBBWBMNRKRS", OracleType.NVarChar).Value = dwData["WBBWBMNRKRS"].ToString();
                    or1.Parameters.Add("WBBWBMLFDNR", OracleType.NVarChar).Value = dwData["WBBWBMLFDNR"].ToString();
                    or1.Parameters.Add("WBBWBMPOS", OracleType.NVarChar).Value = dwData["WBBWBMPOS"].ToString();
                    or1.Parameters.Add("WBBSCHUSS", OracleType.NVarChar).Value = dwData["WBBSCHUSS"].ToString();
                    or1.Parameters.Add("WBBWERKE", OracleType.NVarChar).Value = dwData["WBBWERKE"].ToString();
                    or1.Parameters.Add("WBBLIEF", OracleType.NVarChar).Value = dwData["WBBLIEF"].ToString();
                    or1.Parameters.Add("WBBBAHN", OracleType.NVarChar).Value = dwData["WBBBAHN"].ToString();
                    or1.Parameters.Add("WBBBAHNMAX", OracleType.NVarChar).Value = dwData["WBBBAHNMAX"].ToString();
                    or1.Parameters.Add("WBBWLO", OracleType.NVarChar).Value = dwData["WBBWLO"].ToString();
                    or1.Parameters.Add("WBBWLB", OracleType.NVarChar).Value = dwData["WBBWLB"].ToString();
                    or1.Parameters.Add("WBBWLP", OracleType.NVarChar).Value = dwData["WBBWLP"].ToString();
                    or1.Parameters.Add("WBBWAUFBKZ", OracleType.NVarChar).Value = dwData["WBBWAUFBKZ"].ToString();
                    or1.Parameters.Add("WBBKANTE", OracleType.NVarChar).Value = dwData["WBBKANTE"].ToString();
                    or1.Parameters.Add("WBBSOLLKZ", OracleType.NVarChar).Value = dwData["WBBSOLLKZ"].ToString();
                    or1.Parameters.Add("WBBMATAB", OracleType.NVarChar).Value = dwData["WBBMATAB"].ToString();
                    or1.Parameters.Add("WBBWJJJJ", OracleType.NVarChar).Value = dwData["WBBWJJJJ"].ToString();
                    or1.Parameters.Add("WBBWBNR", OracleType.NVarChar).Value = dwData["WBBWBNR"].ToString();
                    or1.Parameters.Add("WBBFLZZUGDAT", OracleType.NVarChar).Value = dwData["WBBFLZZUGDAT"].ToString();
                    or1.Parameters.Add("WBBISTKLGFA", OracleType.NVarChar).Value = dwData["WBBISTKLGFA"].ToString();
                    or1.Parameters.Add("WBBISTKLGF", OracleType.NVarChar).Value = dwData["WBBISTKLGF"].ToString();
                    or1.Parameters.Add("WBBFRTWSKZ", OracleType.NVarChar).Value = dwData["WBBFRTWSKZ"].ToString();
                    or1.Parameters.Add("WBBLTPOS", OracleType.NVarChar).Value = dwData["WBBLTPOS"].ToString();
                    or1.Parameters.Add("WBBILGFBT", OracleType.NVarChar).Value = dwData["WBBILGFBT"].ToString();
                    or1.Parameters.Add("WBBILGRBT", OracleType.NVarChar).Value = dwData["WBBILGRBT"].ToString();
                    or1.Parameters.Add("WBBIBRTFV", OracleType.NVarChar).Value = dwData["WBBIBRTFV"].ToString();
                    or1.Parameters.Add("WBBIBRTFB", OracleType.NVarChar).Value = dwData["WBBIBRTFB"].ToString();
                    or1.Parameters.Add("WBBFEUCHTE", OracleType.NVarChar).Value = dwData["WBBFEUCHTE"].ToString();
                    or1.Parameters.Add("WBBLIEFSCH", OracleType.NVarChar).Value = dwData["WBBLIEFSCH"].ToString();
                    or1.Parameters.Add("WBBKDPART", OracleType.NVarChar).Value = dwData["WBBKDPART"].ToString();
                    or1.Parameters.Add("WBBSCHLICHTEKZ", OracleType.NVarChar).Value = dwData["WBBSCHLICHTEKZ"].ToString();
                    or1.Parameters.Add("WBBASWAKZ", OracleType.NVarChar).Value = dwData["WBBASWAKZ"].ToString();
                    or1.Parameters.Add("WBBASART", OracleType.NVarChar).Value = dwData["WBBASART"].ToString();
                    or1.Parameters.Add("WBBASVAR", OracleType.NVarChar).Value = dwData["WBBASVAR"].ToString();
                    or1.Parameters.Add("WBBFARBEALT", OracleType.NVarChar).Value = dwData["WBBFARBEALT"].ToString();
                    or1.Parameters.Add("WBBCOLALT", OracleType.NVarChar).Value = dwData["WBBCOLALT"].ToString();
                    or1.Parameters.Add("WBBDESSALT", OracleType.NVarChar).Value = dwData["WBBDESSALT"].ToString();
                    or1.Parameters.Add("WBBBESALT", OracleType.NVarChar).Value = dwData["WBBBESALT"].ToString();
                    or1.Parameters.Add("WBBZUSTANDA", OracleType.NVarChar).Value = dwData["WBBZUSTANDA"].ToString();
                    or1.Parameters.Add("WBBMASSKZ", OracleType.NVarChar).Value = dwData["WBBMASSKZ"].ToString();
                    or1.Parameters.Add("WBBFJJJJ", OracleType.NVarChar).Value = dwData["WBBFJJJJ"].ToString();
                    or1.Parameters.Add("WBBFBNR", OracleType.NVarChar).Value = dwData["WBBFBNR"].ToString();
                    or1.Parameters.Add("WBBRETOURKZ", OracleType.NVarChar).Value = dwData["WBBRETOURKZ"].ToString();
                    or1.Parameters.Add("WBBREAUFKRS", OracleType.NVarChar).Value = dwData["WBBREAUFKRS"].ToString();
                    or1.Parameters.Add("WBBREAUFLFD", OracleType.NVarChar).Value = dwData["WBBREAUFLFD"].ToString();
                    or1.Parameters.Add("WBBREAUFPOS", OracleType.NVarChar).Value = dwData["WBBREAUFPOS"].ToString();
                    or1.Parameters.Add("WBBREAFOLGE", OracleType.NVarChar).Value = dwData["WBBREAFOLGE"].ToString();
                    or1.Parameters.Add("WBBTPA", OracleType.NVarChar).Value = dwData["WBBTPA"].ToString();
                    or1.Parameters.Add("WBBKOMMNR", OracleType.NVarChar).Value = dwData["WBBKOMMNR"].ToString();
                    or1.Parameters.Add("WBBALIEFSCH", OracleType.NVarChar).Value = dwData["WBBALIEFSCH"].ToString();
                    or1.Parameters.Add("WBBPACKNR", OracleType.NVarChar).Value = dwData["WBBPACKNR"].ToString();
                    or1.Parameters.Add("WBBPACKAUTO", OracleType.NVarChar).Value = dwData["WBBPACKAUTO"].ToString();
                    or1.Parameters.Add("WBBRUEKZ", OracleType.NVarChar).Value = dwData["WBBRUEKZ"].ToString();
                    or1.Parameters.Add("WBBURLB", OracleType.NVarChar).Value = dwData["WBBURLB"].ToString();
                    or1.Parameters.Add("WBBURLP", OracleType.NVarChar).Value = dwData["WBBURLP"].ToString();
                    or1.Parameters.Add("WBBURAKZ", OracleType.NVarChar).Value = dwData["WBBURAKZ"].ToString();
                    or1.Parameters.Add("WBBVERSDAT", OracleType.NVarChar).Value = dwData["WBBVERSDAT"].ToString();
                    or1.Parameters.Add("WBBVERSANDKZ", OracleType.NVarChar).Value = dwData["WBBVERSANDKZ"].ToString();
                    or1.Parameters.Add("WBBURLIEFSCH", OracleType.NVarChar).Value = dwData["WBBURLIEFSCH"].ToString();
                    or1.Parameters.Add("WBBARECHNR", OracleType.NVarChar).Value = dwData["WBBARECHNR"].ToString();
                    or1.Parameters.Add("WBBFERTKZ", OracleType.NVarChar).Value = dwData["WBBFERTKZ"].ToString();
                    or1.Parameters.Add("WBBEGKZ", OracleType.NVarChar).Value = dwData["WBBEGKZ"].ToString();
                    or1.Parameters.Add("WBBBEM", OracleType.NVarChar).Value = dwData["WBBBEM"].ToString();
                    or1.Parameters.Add("WBBTXSCHL", OracleType.NVarChar).Value = dwData["WBBTXSCHL"].ToString();
                    or1.Parameters.Add("WBBHHK1", OracleType.NVarChar).Value = dwData["WBBHHK1"].ToString();
                    or1.Parameters.Add("WBBHHK2", OracleType.NVarChar).Value = dwData["WBBHHK2"].ToString();
                    or1.Parameters.Add("WBBHHK3", OracleType.NVarChar).Value = dwData["WBBHHK3"].ToString();
                    or1.Parameters.Add("WBBHHK4", OracleType.NVarChar).Value = dwData["WBBHHK4"].ToString();
                    or1.Parameters.Add("WBBHHK5", OracleType.NVarChar).Value = dwData["WBBHHK5"].ToString();
                    or1.Parameters.Add("WBBHHK6", OracleType.NVarChar).Value = dwData["WBBHHK6"].ToString();
                    or1.Parameters.Add("WBBHHK7", OracleType.NVarChar).Value = dwData["WBBHHK7"].ToString();
                    or1.Parameters.Add("WBBHHK8", OracleType.NVarChar).Value = dwData["WBBHHK8"].ToString();
                    or1.Parameters.Add("WBBHHK9", OracleType.NVarChar).Value = dwData["WBBHHK9"].ToString();
                    or1.Parameters.Add("WBBHHK10", OracleType.NVarChar).Value = dwData["WBBHHK10"].ToString();
                    or1.Parameters.Add("WBBHHKG", OracleType.NVarChar).Value = dwData["WBBHHKG"].ToString();
                    or1.Parameters.Add("WBBAHK1", OracleType.NVarChar).Value = dwData["WBBAHK1"].ToString();
                    or1.Parameters.Add("WBBAHK2", OracleType.NVarChar).Value = dwData["WBBAHK2"].ToString();
                    or1.Parameters.Add("WBBAHK3", OracleType.NVarChar).Value = dwData["WBBAHK3"].ToString();
                    or1.Parameters.Add("WBBAHK4", OracleType.NVarChar).Value = dwData["WBBAHK4"].ToString();
                    or1.Parameters.Add("WBBAHK5", OracleType.NVarChar).Value = dwData["WBBAHK5"].ToString();
                    or1.Parameters.Add("WBBAHK6", OracleType.NVarChar).Value = dwData["WBBAHK6"].ToString();
                    or1.Parameters.Add("WBBAHK7", OracleType.NVarChar).Value = dwData["WBBAHK7"].ToString();
                    or1.Parameters.Add("WBBAHK8", OracleType.NVarChar).Value = dwData["WBBAHK8"].ToString();
                    or1.Parameters.Add("WBBAHK9", OracleType.NVarChar).Value = dwData["WBBAHK9"].ToString();
                    or1.Parameters.Add("WBBAHK10", OracleType.NVarChar).Value = dwData["WBBAHK10"].ToString();
                    or1.Parameters.Add("WBBAHKG", OracleType.NVarChar).Value = dwData["WBBAHKG"].ToString();
                    or1.Parameters.Add("WBBABPZAB", OracleType.NVarChar).Value = dwData["WBBABPZAB"].ToString();
                    or1.Parameters.Add("WBBABDATAB", OracleType.NVarChar).Value = dwData["WBBABDATAB"].ToString();
                    or1.Parameters.Add("WBBNEUBEN", OracleType.NVarChar).Value = dwData["WBBNEUBEN"].ToString();
                    or1.Parameters.Add("WBBNEUDAT", OracleType.NVarChar).Value = dwData["WBBNEUDAT"].ToString();
                    or1.Parameters.Add("WBBAENDBEN", OracleType.NVarChar).Value = dwData["WBBAENDBEN"].ToString();
                    or1.Parameters.Add("WBBAENDDAT", OracleType.NVarChar).Value = dwData["WBBAENDDAT"].ToString();
                    or1.Parameters.Add("WBBAENDZL", OracleType.NVarChar).Value = dwData["WBBAENDZL"].ToString();
                    or1.Parameters.Add("WBBWS", OracleType.NVarChar).Value = dwData["WBBWS"].ToString();
                    or1.Parameters.Add("WBBWSNO", OracleType.NVarChar).Value = dwData["WBBWSNO"].ToString();
                    or1.Parameters.Add("WBBFILLER", OracleType.NVarChar).Value = dwData["WBBFILLER"].ToString();
                    #endregion
                    break;
                case 2:
                    #region====Command====
                    or1.CommandText = "UPDATE WBBST SET "
                        + "WBBPACKNR=:WBBPACKNR "
                        + " ,WBBDPART2=:WBBDPART2"
                        +" ,WBBAENDBEN = 'INTEX   '"
                        + " WHERE  "
                        + "  WBBMANDANT=:WBBMANDANT AND WBBSTKNR=:WBBSTKNR";
                    #endregion
                    #region====Parameters====
                    or1.Parameters.Add("WBBMANDANT", OracleType.NVarChar).Value = dwData["WBBMANDANT"].ToString();
                    or1.Parameters.Add("WBBSTKNR", OracleType.NVarChar).Value = dwData["WBBSTKNR"].ToString();
                    or1.Parameters.Add("WBBPACKNR", OracleType.NVarChar).Value = dwData["WBBPACKNR"].ToString();
                    or1.Parameters.Add("WBBDPART2", OracleType.NVarChar).Value = dwData["WBBDPART2"].ToString();                    
                    #endregion
                    break;
            }

            Connect2Proxy(or1);
        }
        public void UpdateWBBST(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            DataSet result = new DataSet();
            or1 = OracleDB.CreateCommand();

            #region====Command====
            or1.CommandText = "UPDATE WBBST SET "
+ "WBBMANDANT=:WBBMANDANT,"
+ "WBBRWKRS=:WBBRWKRS,"
+ "WBBRWLFD=:WBBRWLFD,"
+ "WBBPOS=:WBBPOS,"
+ "WBBWERK=:WBBWERK,"
+ "WBBABT=:WBBABT,"
+ "WBBKUNDNR=:WBBKUNDNR,"
+ "WBBSTKNR=:WBBSTKNR,"
+ "WBBWAKZ=:WBBWAKZ,"
+ "WBBART=:WBBART,"
+ "WBBDESS=:WBBDESS,"
+ "WBBCOLORIT=:WBBCOLORIT,"
+ "WBBFARBE=:WBBFARBE,"
+ "WBBBESCHICH=:WBBBESCHICH,"
+ "WBBVAR=:WBBVAR,"
+ "WBBKOLL=:WBBKOLL,"
+ "WBBVKART=:WBBVKART,"
+ "WBBVKFARBE=:WBBVKFARBE,"
+ "WBBARTABW=:WBBARTABW,"
+ "WBBARTKUNDNR=:WBBARTKUNDNR,"
+ "WBBENTWKZ=:WBBENTWKZ,"
+ "WBBSSTKLG=:WBBSSTKLG,"
+ "WBBSGEW=:WBBSGEW,"
+ "WBBSBRT=:WBBSBRT,"
+ "WBBISTKLG=:WBBISTKLG,"
+ "WBBIGEW=:WBBIGEW,"
+ "WBBIBRT=:WBBIBRT,"
+ "WBBBRGEW=:WBBBRGEW,"
+ "WBBDM=:WBBDM,"
+ "WBBVOL=:WBBVOL,"
+ "WBBIGEWKZ=:WBBIGEWKZ,"
+ "WBBIANZ=:WBBIANZ,"
+ "WBBMABRT1=:WBBMABRT1,"
+ "WBBMASTKLG1=:WBBMASTKLG1,"
+ "WBBMABRT2=:WBBMABRT2,"
+ "WBBMASTKLG2=:WBBMASTKLG2,"
+ "WBBMABRT3=:WBBMABRT3,"
+ "WBBMASTKLG3=:WBBMASTKLG3,"
+ "WBBMABRT4=:WBBMABRT4,"
+ "WBBMASTKLG4=:WBBMASTKLG4,"
+ "WBBMABRT5=:WBBMABRT5,"
+ "WBBMASTKLG5=:WBBMASTKLG5,"
+ "WBBINDAT=:WBBINDAT,"
+ "WBBINBSTMTR=:WBBINBSTMTR,"
+ "WBBINBSTKG=:WBBINBSTKG,"
+ "WBBIPREIS=:WBBIPREIS,"
+ "WBBWARSCH=:WBBWARSCH,"
+ "WBBWDATUM=:WBBWDATUM,"
+ "WBBWSCHICHT=:WBBWSCHICHT,"
+ "WBBWMNRKRS=:WBBWMNRKRS,"
+ "WBBWMLFDNR=:WBBWMLFDNR,"
+ "WBBWMPOS=:WBBWMPOS,"
+ "WBBRE=:WBBRE,"
+ "WBBRENETTO=:WBBRENETTO,"
+ "WBBREVGUET=:WBBREVGUET,"
+ "WBBRS=:WBBRS,"
+ "WBBRSNETTO=:WBBRSNETTO,"
+ "WBBRSVGUET=:WBBRSVGUET,"
+ "WBBVE=:WBBVE,"
+ "WBBVENETTO=:WBBVENETTO,"
+ "WBBVEVGUET=:WBBVEVGUET,"
+ "WBBVS=:WBBVS,"
+ "WBBVSNETTO=:WBBVSNETTO,"
+ "WBBVSVGUET=:WBBVSVGUET,"
+ "WBBANZTEILE=:WBBANZTEILE,"
+ "WBBVERSION=:WBBVERSION,"
+ "WBBTAX=:WBBTAX,"
+ "WBBZENSUR=:WBBZENSUR,"
+ "WBBZENSURKZ=:WBBZENSURKZ,"
+ "WBBUBRT=:WBBUBRT,"
+ "WBBZAFOLGE=:WBBZAFOLGE,"
+ "WBBNAFOLGE=:WBBNAFOLGE,"
+ "WBBZLNR=:WBBZLNR,"
+ "WBBAUFMSL=:WBBAUFMSL,"
+ "WBBZUSAM=:WBBZUSAM,"
+ "WBBMAART=:WBBMAART,"
+ "WBBPACKTYP=:WBBPACKTYP,"
+ "WBBROLLR=:WBBROLLR,"
+ "WBBAUFMPOS=:WBBAUFMPOS,"
+ "WBBKONFKZ=:WBBKONFKZ,"
+ "WBBKETTELN=:WBBKETTELN,"
+ "WBBSHSTK1=:WBBSHSTK1,"
+ "WBBSHBRT1=:WBBSHBRT1,"
+ "WBBSHSTKLG1=:WBBSHSTKLG1,"
+ "WBBSHSTK2=:WBBSHSTK2,"
+ "WBBSHBRT2=:WBBSHBRT2,"
+ "WBBSHSTKLG2=:WBBSHSTKLG2,"
+ "WBBSHSTK3=:WBBSHSTK3,"
+ "WBBSHBRT3=:WBBSHBRT3,"
+ "WBBSHSTKLG3=:WBBSHSTKLG3,"
+ "WBBSHSTK4=:WBBSHSTK4,"
+ "WBBSHBRT4=:WBBSHBRT4,"
+ "WBBSHSTKLG4=:WBBSHSTKLG4,"
+ "WBBSHSTK5=:WBBSHSTK5,"
+ "WBBSHBRT5=:WBBSHBRT5,"
+ "WBBSHSTKLG5=:WBBSHSTKLG5,"
+ "WBBSTKNRK=:WBBSTKNRK,"
+ "WBBLO=:WBBLO,"
+ "WBBLB=:WBBLB,"
+ "WBBKZ=:WBBKZ,"
+ "WBBLP=:WBBLP,"
+ "WBBAUFBKZ=:WBBAUFBKZ,"
+ "WBBGEBNR=:WBBGEBNR,"
+ "WBBGEBPOS=:WBBGEBPOS,"
+ "WBBSPSTA=:WBBSPSTA,"
+ "WBBSPGRD=:WBBSPGRD,"
+ "WBBERLKZ=:WBBERLKZ,"
+ "WBBAUFTYP=:WBBAUFTYP,"
+ "WBBAUFKRS=:WBBAUFKRS,"
+ "WBBAUFLFD=:WBBAUFLFD,"
+ "WBBAUFPOS=:WBBAUFPOS,"
+ "WBBTP=:WBBTP,"
+ "WBBFOLGE=:WBBFOLGE,"
+ "WBBAFOLGEVON=:WBBAFOLGEVON,"
+ "WBBRAFOLGE=:WBBRAFOLGE,"
+ "WBBMAFOLGE=:WBBMAFOLGE,"
+ "WBBRSTKLG=:WBBRSTKLG,"
+ "WBBRGEW=:WBBRGEW,"
+ "WBBLGAE=:WBBLGAE,"
+ "WBBGEWAE=:WBBGEWAE,"
+ "WBBPOOL=:WBBPOOL,"
+ "WBBAUTZU=:WBBAUTZU,"
+ "WBBWDUPOS=:WBBWDUPOS,"
+ "WBBRBENID=:WBBRBENID,"
+ "WBBRDATB=:WBBRDATB,"
+ "WBBRDAT=:WBBRDAT,"
+ "WBBRBEM=:WBBRBEM,"
+ "WBBRKUNDNR=:WBBRKUNDNR,"
+ "WBBDPART=:WBBDPART,"
+ "WBBDPART2=:WBBDPART2,"
+ "WBBZUSTAND=:WBBZUSTAND,"
+ "WBBFARBN=:WBBFARBN,"
+ "WBBSPKZ=:WBBSPKZ,"
+ "WBBCUKZ=:WBBCUKZ,"
+ "WBBDISPOART=:WBBDISPOART,"
+ "WBBDISPOVAR=:WBBDISPOVAR,"
+ "WBBAUSFFRB=:WBBAUSFFRB,"
+ "WBBAUSFGRI=:WBBAUSFGRI,"
+ "WBBAUSFQUAL=:WBBAUSFQUAL,"
+ "WBBQUALST=:WBBQUALST,"
+ "WBBQPKT=:WBBQPKT,"
+ "WBBQPKTH=:WBBQPKTH,"
+ "WBBQPKTL=:WBBQPKTL,"
+ "WBBQPKTLH=:WBBQPKTLH,"
+ "WBBVB=:WBBVB,"
+ "WBBVG=:WBBVG,"
+ "WBBVLVB=:WBBVLVB,"
+ "WBBVLVG=:WBBVLVG,"
+ "WBBVLSACHB=:WBBVLSACHB,"
+ "WBBVLGEGEN=:WBBVLGEGEN,"
+ "WBBPRKUNDNR=:WBBPRKUNDNR,"
+ "WBBGENNR=:WBBGENNR,"
+ "WBBELOA=:WBBELOA,"
+ "WBBELOB=:WBBELOB,"
+ "WBBURAUFKRS=:WBBURAUFKRS,"
+ "WBBURAUFLFD=:WBBURAUFLFD,"
+ "WBBURAUFPOS=:WBBURAUFPOS,"
+ "WBBVKNPOS=:WBBVKNPOS,"
+ "WBBURLAND=:WBBURLAND,"
+ "WBBVERZKZ=:WBBVERZKZ,"
+ "WBBTSTKLG=:WBBTSTKLG,"
+ "WBBTANZ=:WBBTANZ,"
+ "WBBURPOS=:WBBURPOS,"
+ "WBBTEILPOS=:WBBTEILPOS,"
+ "WBBECKZ=:WBBECKZ,"
+ "WBBTLGAFOLGE=:WBBTLGAFOLGE,"
+ "WBBZMT=:WBBZMT,"
+ "WBBANZSNT=:WBBANZSNT,"
+ "WBBTLBRT=:WBBTLBRT,"
+ "WBBTLSTKLG=:WBBTLSTKLG,"
+ "WBBTLRICHT=:WBBTLRICHT,"
+ "WBBDRKZ1=:WBBDRKZ1,"
+ "WBBDRKZ2=:WBBDRKZ2,"
+ "WBBEINDAT=:WBBEINDAT,"
+ "WBBWSTKLG=:WBBWSTKLG,"
+ "WBBWBRT=:WBBWBRT,"
+ "WBBWBMNRKRS=:WBBWBMNRKRS,"
+ "WBBWBMLFDNR=:WBBWBMLFDNR,"
+ "WBBWBMPOS=:WBBWBMPOS,"
+ "WBBSCHUSS=:WBBSCHUSS,"
+ "WBBWERKE=:WBBWERKE,"
+ "WBBLIEF=:WBBLIEF,"
+ "WBBBAHN=:WBBBAHN,"
+ "WBBBAHNMAX=:WBBBAHNMAX,"
+ "WBBWLO=:WBBWLO,"
+ "WBBWLB=:WBBWLB,"
+ "WBBWLP=:WBBWLP,"
+ "WBBWAUFBKZ=:WBBWAUFBKZ,"
+ "WBBKANTE=:WBBKANTE,"
+ "WBBSOLLKZ=:WBBSOLLKZ,"
+ "WBBMATAB=:WBBMATAB,"
+ "WBBWJJJJ=:WBBWJJJJ,"
+ "WBBWBNR=:WBBWBNR,"
+ "WBBFLZZUGDAT=:WBBFLZZUGDAT,"
+ "WBBISTKLGFA=:WBBISTKLGFA,"
+ "WBBISTKLGF=:WBBISTKLGF,"
+ "WBBFRTWSKZ=:WBBFRTWSKZ,"
+ "WBBLTPOS=:WBBLTPOS,"
+ "WBBILGFBT=:WBBILGFBT,"
+ "WBBILGRBT=:WBBILGRBT,"
+ "WBBIBRTFV=:WBBIBRTFV,"
+ "WBBIBRTFB=:WBBIBRTFB,"
+ "WBBFEUCHTE=:WBBFEUCHTE,"
+ "WBBLIEFSCH=:WBBLIEFSCH,"
+ "WBBKDPART=:WBBKDPART,"
+ "WBBSCHLICHTEKZ=:WBBSCHLICHTEKZ,"
+ "WBBASWAKZ=:WBBASWAKZ,"
+ "WBBASART=:WBBASART,"
+ "WBBASVAR=:WBBASVAR,"
+ "WBBFARBEALT=:WBBFARBEALT,"
+ "WBBCOLALT=:WBBCOLALT,"
+ "WBBDESSALT=:WBBDESSALT,"
+ "WBBBESALT=:WBBBESALT,"
+ "WBBZUSTANDA=:WBBZUSTANDA,"
+ "WBBMASSKZ=:WBBMASSKZ,"
+ "WBBFJJJJ=:WBBFJJJJ,"
+ "WBBFBNR=:WBBFBNR,"
+ "WBBRETOURKZ=:WBBRETOURKZ,"
+ "WBBREAUFKRS=:WBBREAUFKRS,"
+ "WBBREAUFLFD=:WBBREAUFLFD,"
+ "WBBREAUFPOS=:WBBREAUFPOS,"
+ "WBBREAFOLGE=:WBBREAFOLGE,"
+ "WBBTPA=:WBBTPA,"
+ "WBBKOMMNR=:WBBKOMMNR,"
+ "WBBALIEFSCH=:WBBALIEFSCH,"
+ "WBBPACKNR=:WBBPACKNR,"
+ "WBBPACKAUTO=:WBBPACKAUTO,"
+ "WBBRUEKZ=:WBBRUEKZ,"
+ "WBBURLB=:WBBURLB,"
+ "WBBURLP=:WBBURLP,"
+ "WBBURAKZ=:WBBURAKZ,"
+ "WBBVERSDAT=:WBBVERSDAT,"
+ "WBBVERSANDKZ=:WBBVERSANDKZ,"
+ "WBBURLIEFSCH=:WBBURLIEFSCH,"
+ "WBBARECHNR=:WBBARECHNR,"
+ "WBBFERTKZ=:WBBFERTKZ,"
+ "WBBEGKZ=:WBBEGKZ,"
+ "WBBBEM=:WBBBEM,"
+ "WBBTXSCHL=:WBBTXSCHL,"
+ "WBBHHK1=:WBBHHK1,"
+ "WBBHHK2=:WBBHHK2,"
+ "WBBHHK3=:WBBHHK3,"
+ "WBBHHK4=:WBBHHK4,"
+ "WBBHHK5=:WBBHHK5,"
+ "WBBHHK6=:WBBHHK6,"
+ "WBBHHK7=:WBBHHK7,"
+ "WBBHHK8=:WBBHHK8,"
+ "WBBHHK9=:WBBHHK9,"
+ "WBBHHK10=:WBBHHK10,"
+ "WBBHHKG=:WBBHHKG,"
+ "WBBAHK1=:WBBAHK1,"
+ "WBBAHK2=:WBBAHK2,"
+ "WBBAHK3=:WBBAHK3,"
+ "WBBAHK4=:WBBAHK4,"
+ "WBBAHK5=:WBBAHK5,"
+ "WBBAHK6=:WBBAHK6,"
+ "WBBAHK7=:WBBAHK7,"
+ "WBBAHK8=:WBBAHK8,"
+ "WBBAHK9=:WBBAHK9,"
+ "WBBAHK10=:WBBAHK10,"
+ "WBBAHKG=:WBBAHKG,"
+ "WBBABPZAB=:WBBABPZAB,"
+ "WBBABDATAB=:WBBABDATAB,"
+ "WBBNEUBEN=:WBBNEUBEN,"
+ "WBBNEUDAT=:WBBNEUDAT,"
+ "WBBAENDBEN=:WBBAENDBEN,"
+ "WBBAENDDAT=:WBBAENDDAT,"
+ "WBBAENDZL=:WBBAENDZL,"
+ "WBBWS=:WBBWS,"
+ "WBBWSNO=:WBBWSNO,"
+ "WBBFILLER=:WBBFILLER "
+ " WHERE  "
               + "  WBBMANDANT=:WBBMANDANT AND WBBRWKRS=:WBBRWKRS AND WBBRWLFD=:WBBRWLFD AND WBBPOS=:WBBPOS";
            #endregion

            #region====Parameters====
            or1.Parameters.Add("WBBMANDANT", OracleType.NVarChar).Value = dwData["WBBMANDANT"].ToString();
            or1.Parameters.Add("WBBRWKRS", OracleType.NVarChar).Value = dwData["WBBRWKRS"].ToString();
            or1.Parameters.Add("WBBRWLFD", OracleType.NVarChar).Value = dwData["WBBRWLFD"].ToString();
            or1.Parameters.Add("WBBPOS", OracleType.NVarChar).Value = dwData["WBBPOS"].ToString();
            or1.Parameters.Add("WBBWERK", OracleType.NVarChar).Value = dwData["WBBWERK"].ToString();
            or1.Parameters.Add("WBBABT", OracleType.NVarChar).Value = dwData["WBBABT"].ToString();
            or1.Parameters.Add("WBBKUNDNR", OracleType.NVarChar).Value = dwData["WBBKUNDNR"].ToString();
            or1.Parameters.Add("WBBSTKNR", OracleType.NVarChar).Value = dwData["WBBSTKNR"].ToString();
            or1.Parameters.Add("WBBWAKZ", OracleType.NVarChar).Value = dwData["WBBWAKZ"].ToString();
            or1.Parameters.Add("WBBART", OracleType.NVarChar).Value = dwData["WBBART"].ToString();
            or1.Parameters.Add("WBBDESS", OracleType.NVarChar).Value = dwData["WBBDESS"].ToString();
            or1.Parameters.Add("WBBCOLORIT", OracleType.NVarChar).Value = dwData["WBBCOLORIT"].ToString();
            or1.Parameters.Add("WBBFARBE", OracleType.NVarChar).Value = dwData["WBBFARBE"].ToString();
            or1.Parameters.Add("WBBBESCHICH", OracleType.NVarChar).Value = dwData["WBBBESCHICH"].ToString();
            or1.Parameters.Add("WBBVAR", OracleType.NVarChar).Value = dwData["WBBVAR"].ToString();
            or1.Parameters.Add("WBBKOLL", OracleType.NVarChar).Value = dwData["WBBKOLL"].ToString();
            or1.Parameters.Add("WBBVKART", OracleType.NVarChar).Value = dwData["WBBVKART"].ToString();
            or1.Parameters.Add("WBBVKFARBE", OracleType.NVarChar).Value = dwData["WBBVKFARBE"].ToString();
            or1.Parameters.Add("WBBARTABW", OracleType.NVarChar).Value = dwData["WBBARTABW"].ToString();
            or1.Parameters.Add("WBBARTKUNDNR", OracleType.NVarChar).Value = dwData["WBBARTKUNDNR"].ToString();
            or1.Parameters.Add("WBBENTWKZ", OracleType.NVarChar).Value = dwData["WBBENTWKZ"].ToString();
            or1.Parameters.Add("WBBSSTKLG", OracleType.NVarChar).Value = dwData["WBBSSTKLG"].ToString();
            or1.Parameters.Add("WBBSGEW", OracleType.NVarChar).Value = dwData["WBBSGEW"].ToString();
            or1.Parameters.Add("WBBSBRT", OracleType.NVarChar).Value = dwData["WBBSBRT"].ToString();
            or1.Parameters.Add("WBBISTKLG", OracleType.NVarChar).Value = dwData["WBBISTKLG"].ToString();
            or1.Parameters.Add("WBBIGEW", OracleType.NVarChar).Value = dwData["WBBIGEW"].ToString();
            or1.Parameters.Add("WBBIBRT", OracleType.NVarChar).Value = dwData["WBBIBRT"].ToString();
            or1.Parameters.Add("WBBBRGEW", OracleType.NVarChar).Value = dwData["WBBBRGEW"].ToString();
            or1.Parameters.Add("WBBDM", OracleType.NVarChar).Value = dwData["WBBDM"].ToString();
            or1.Parameters.Add("WBBVOL", OracleType.NVarChar).Value = dwData["WBBVOL"].ToString();
            or1.Parameters.Add("WBBIGEWKZ", OracleType.NVarChar).Value = dwData["WBBIGEWKZ"].ToString();
            or1.Parameters.Add("WBBIANZ", OracleType.NVarChar).Value = dwData["WBBIANZ"].ToString();
            or1.Parameters.Add("WBBMABRT1", OracleType.NVarChar).Value = dwData["WBBMABRT1"].ToString();
            or1.Parameters.Add("WBBMASTKLG1", OracleType.NVarChar).Value = dwData["WBBMASTKLG1"].ToString();
            or1.Parameters.Add("WBBMABRT2", OracleType.NVarChar).Value = dwData["WBBMABRT2"].ToString();
            or1.Parameters.Add("WBBMASTKLG2", OracleType.NVarChar).Value = dwData["WBBMASTKLG2"].ToString();
            or1.Parameters.Add("WBBMABRT3", OracleType.NVarChar).Value = dwData["WBBMABRT3"].ToString();
            or1.Parameters.Add("WBBMASTKLG3", OracleType.NVarChar).Value = dwData["WBBMASTKLG3"].ToString();
            or1.Parameters.Add("WBBMABRT4", OracleType.NVarChar).Value = dwData["WBBMABRT4"].ToString();
            or1.Parameters.Add("WBBMASTKLG4", OracleType.NVarChar).Value = dwData["WBBMASTKLG4"].ToString();
            or1.Parameters.Add("WBBMABRT5", OracleType.NVarChar).Value = dwData["WBBMABRT5"].ToString();
            or1.Parameters.Add("WBBMASTKLG5", OracleType.NVarChar).Value = dwData["WBBMASTKLG5"].ToString();
            or1.Parameters.Add("WBBINDAT", OracleType.NVarChar).Value = dwData["WBBINDAT"].ToString();
            or1.Parameters.Add("WBBINBSTMTR", OracleType.NVarChar).Value = dwData["WBBINBSTMTR"].ToString();
            or1.Parameters.Add("WBBINBSTKG", OracleType.NVarChar).Value = dwData["WBBINBSTKG"].ToString();
            or1.Parameters.Add("WBBIPREIS", OracleType.NVarChar).Value = dwData["WBBIPREIS"].ToString();
            or1.Parameters.Add("WBBWARSCH", OracleType.NVarChar).Value = dwData["WBBWARSCH"].ToString();
            or1.Parameters.Add("WBBWDATUM", OracleType.NVarChar).Value = dwData["WBBWDATUM"].ToString();
            or1.Parameters.Add("WBBWSCHICHT", OracleType.NVarChar).Value = dwData["WBBWSCHICHT"].ToString();
            or1.Parameters.Add("WBBWMNRKRS", OracleType.NVarChar).Value = dwData["WBBWMNRKRS"].ToString();
            or1.Parameters.Add("WBBWMLFDNR", OracleType.NVarChar).Value = dwData["WBBWMLFDNR"].ToString();
            or1.Parameters.Add("WBBWMPOS", OracleType.NVarChar).Value = dwData["WBBWMPOS"].ToString();
            or1.Parameters.Add("WBBRE", OracleType.NVarChar).Value = dwData["WBBRE"].ToString();
            or1.Parameters.Add("WBBRENETTO", OracleType.NVarChar).Value = dwData["WBBRENETTO"].ToString();
            or1.Parameters.Add("WBBREVGUET", OracleType.NVarChar).Value = dwData["WBBREVGUET"].ToString();
            or1.Parameters.Add("WBBRS", OracleType.NVarChar).Value = dwData["WBBRS"].ToString();
            or1.Parameters.Add("WBBRSNETTO", OracleType.NVarChar).Value = dwData["WBBRSNETTO"].ToString();
            or1.Parameters.Add("WBBRSVGUET", OracleType.NVarChar).Value = dwData["WBBRSVGUET"].ToString();
            or1.Parameters.Add("WBBVE", OracleType.NVarChar).Value = dwData["WBBVE"].ToString();
            or1.Parameters.Add("WBBVENETTO", OracleType.NVarChar).Value = dwData["WBBVENETTO"].ToString();
            or1.Parameters.Add("WBBVEVGUET", OracleType.NVarChar).Value = dwData["WBBVEVGUET"].ToString();
            or1.Parameters.Add("WBBVS", OracleType.NVarChar).Value = dwData["WBBVS"].ToString();
            or1.Parameters.Add("WBBVSNETTO", OracleType.NVarChar).Value = dwData["WBBVSNETTO"].ToString();
            or1.Parameters.Add("WBBVSVGUET", OracleType.NVarChar).Value = dwData["WBBVSVGUET"].ToString();
            or1.Parameters.Add("WBBANZTEILE", OracleType.NVarChar).Value = dwData["WBBANZTEILE"].ToString();
            or1.Parameters.Add("WBBVERSION", OracleType.NVarChar).Value = dwData["WBBVERSION"].ToString();
            or1.Parameters.Add("WBBTAX", OracleType.NVarChar).Value = dwData["WBBTAX"].ToString();
            or1.Parameters.Add("WBBZENSUR", OracleType.NVarChar).Value = dwData["WBBZENSUR"].ToString();
            or1.Parameters.Add("WBBZENSURKZ", OracleType.NVarChar).Value = dwData["WBBZENSURKZ"].ToString();
            or1.Parameters.Add("WBBUBRT", OracleType.NVarChar).Value = dwData["WBBUBRT"].ToString();
            or1.Parameters.Add("WBBZAFOLGE", OracleType.NVarChar).Value = dwData["WBBZAFOLGE"].ToString();
            or1.Parameters.Add("WBBNAFOLGE", OracleType.NVarChar).Value = dwData["WBBNAFOLGE"].ToString();
            or1.Parameters.Add("WBBZLNR", OracleType.NVarChar).Value = dwData["WBBZLNR"].ToString();
            or1.Parameters.Add("WBBAUFMSL", OracleType.NVarChar).Value = dwData["WBBAUFMSL"].ToString();
            or1.Parameters.Add("WBBZUSAM", OracleType.NVarChar).Value = dwData["WBBZUSAM"].ToString();
            or1.Parameters.Add("WBBMAART", OracleType.NVarChar).Value = dwData["WBBMAART"].ToString();
            or1.Parameters.Add("WBBPACKTYP", OracleType.NVarChar).Value = dwData["WBBPACKTYP"].ToString();
            or1.Parameters.Add("WBBROLLR", OracleType.NVarChar).Value = dwData["WBBROLLR"].ToString();
            or1.Parameters.Add("WBBAUFMPOS", OracleType.NVarChar).Value = dwData["WBBAUFMPOS"].ToString();
            or1.Parameters.Add("WBBKONFKZ", OracleType.NVarChar).Value = dwData["WBBKONFKZ"].ToString();
            or1.Parameters.Add("WBBKETTELN", OracleType.NVarChar).Value = dwData["WBBKETTELN"].ToString();
            or1.Parameters.Add("WBBSHSTK1", OracleType.NVarChar).Value = dwData["WBBSHSTK1"].ToString();
            or1.Parameters.Add("WBBSHBRT1", OracleType.NVarChar).Value = dwData["WBBSHBRT1"].ToString();
            or1.Parameters.Add("WBBSHSTKLG1", OracleType.NVarChar).Value = dwData["WBBSHSTKLG1"].ToString();
            or1.Parameters.Add("WBBSHSTK2", OracleType.NVarChar).Value = dwData["WBBSHSTK2"].ToString();
            or1.Parameters.Add("WBBSHBRT2", OracleType.NVarChar).Value = dwData["WBBSHBRT2"].ToString();
            or1.Parameters.Add("WBBSHSTKLG2", OracleType.NVarChar).Value = dwData["WBBSHSTKLG2"].ToString();
            or1.Parameters.Add("WBBSHSTK3", OracleType.NVarChar).Value = dwData["WBBSHSTK3"].ToString();
            or1.Parameters.Add("WBBSHBRT3", OracleType.NVarChar).Value = dwData["WBBSHBRT3"].ToString();
            or1.Parameters.Add("WBBSHSTKLG3", OracleType.NVarChar).Value = dwData["WBBSHSTKLG3"].ToString();
            or1.Parameters.Add("WBBSHSTK4", OracleType.NVarChar).Value = dwData["WBBSHSTK4"].ToString();
            or1.Parameters.Add("WBBSHBRT4", OracleType.NVarChar).Value = dwData["WBBSHBRT4"].ToString();
            or1.Parameters.Add("WBBSHSTKLG4", OracleType.NVarChar).Value = dwData["WBBSHSTKLG4"].ToString();
            or1.Parameters.Add("WBBSHSTK5", OracleType.NVarChar).Value = dwData["WBBSHSTK5"].ToString();
            or1.Parameters.Add("WBBSHBRT5", OracleType.NVarChar).Value = dwData["WBBSHBRT5"].ToString();
            or1.Parameters.Add("WBBSHSTKLG5", OracleType.NVarChar).Value = dwData["WBBSHSTKLG5"].ToString();
            or1.Parameters.Add("WBBSTKNRK", OracleType.NVarChar).Value = dwData["WBBSTKNRK"].ToString();
            or1.Parameters.Add("WBBLO", OracleType.NVarChar).Value = dwData["WBBLO"].ToString();
            or1.Parameters.Add("WBBLB", OracleType.NVarChar).Value = dwData["WBBLB"].ToString();
            or1.Parameters.Add("WBBKZ", OracleType.NVarChar).Value = dwData["WBBKZ"].ToString();
            or1.Parameters.Add("WBBLP", OracleType.NVarChar).Value = dwData["WBBLP"].ToString();
            or1.Parameters.Add("WBBAUFBKZ", OracleType.NVarChar).Value = dwData["WBBAUFBKZ"].ToString();
            or1.Parameters.Add("WBBGEBNR", OracleType.NVarChar).Value = dwData["WBBGEBNR"].ToString();
            or1.Parameters.Add("WBBGEBPOS", OracleType.NVarChar).Value = dwData["WBBGEBPOS"].ToString();
            or1.Parameters.Add("WBBSPSTA", OracleType.NVarChar).Value = dwData["WBBSPSTA"].ToString();
            or1.Parameters.Add("WBBSPGRD", OracleType.NVarChar).Value = dwData["WBBSPGRD"].ToString();
            or1.Parameters.Add("WBBERLKZ", OracleType.NVarChar).Value = dwData["WBBERLKZ"].ToString();
            or1.Parameters.Add("WBBAUFTYP", OracleType.NVarChar).Value = dwData["WBBAUFTYP"].ToString();
            or1.Parameters.Add("WBBAUFKRS", OracleType.NVarChar).Value = dwData["WBBAUFKRS"].ToString();
            or1.Parameters.Add("WBBAUFLFD", OracleType.NVarChar).Value = dwData["WBBAUFLFD"].ToString();
            or1.Parameters.Add("WBBAUFPOS", OracleType.NVarChar).Value = dwData["WBBAUFPOS"].ToString();
            or1.Parameters.Add("WBBTP", OracleType.NVarChar).Value = dwData["WBBTP"].ToString();
            or1.Parameters.Add("WBBFOLGE", OracleType.NVarChar).Value = dwData["WBBFOLGE"].ToString();
            or1.Parameters.Add("WBBAFOLGEVON", OracleType.NVarChar).Value = dwData["WBBAFOLGEVON"].ToString();
            or1.Parameters.Add("WBBRAFOLGE", OracleType.NVarChar).Value = dwData["WBBRAFOLGE"].ToString();
            or1.Parameters.Add("WBBMAFOLGE", OracleType.NVarChar).Value = dwData["WBBMAFOLGE"].ToString();
            or1.Parameters.Add("WBBRSTKLG", OracleType.NVarChar).Value = dwData["WBBRSTKLG"].ToString();
            or1.Parameters.Add("WBBRGEW", OracleType.NVarChar).Value = dwData["WBBRGEW"].ToString();
            or1.Parameters.Add("WBBLGAE", OracleType.NVarChar).Value = dwData["WBBLGAE"].ToString();
            or1.Parameters.Add("WBBGEWAE", OracleType.NVarChar).Value = dwData["WBBGEWAE"].ToString();
            or1.Parameters.Add("WBBPOOL", OracleType.NVarChar).Value = dwData["WBBPOOL"].ToString();
            or1.Parameters.Add("WBBAUTZU", OracleType.NVarChar).Value = dwData["WBBAUTZU"].ToString();
            or1.Parameters.Add("WBBWDUPOS", OracleType.NVarChar).Value = dwData["WBBWDUPOS"].ToString();
            or1.Parameters.Add("WBBRBENID", OracleType.NVarChar).Value = dwData["WBBRBENID"].ToString();
            or1.Parameters.Add("WBBRDATB", OracleType.NVarChar).Value = dwData["WBBRDATB"].ToString();
            or1.Parameters.Add("WBBRDAT", OracleType.NVarChar).Value = dwData["WBBRDAT"].ToString();
            or1.Parameters.Add("WBBRBEM", OracleType.NVarChar).Value = dwData["WBBRBEM"].ToString();
            or1.Parameters.Add("WBBRKUNDNR", OracleType.NVarChar).Value = dwData["WBBRKUNDNR"].ToString();
            or1.Parameters.Add("WBBDPART", OracleType.NVarChar).Value = dwData["WBBDPART"].ToString();
            or1.Parameters.Add("WBBDPART2", OracleType.NVarChar).Value = dwData["WBBDPART2"].ToString();
            or1.Parameters.Add("WBBZUSTAND", OracleType.NVarChar).Value = dwData["WBBZUSTAND"].ToString();
            or1.Parameters.Add("WBBFARBN", OracleType.NVarChar).Value = dwData["WBBFARBN"].ToString();
            or1.Parameters.Add("WBBSPKZ", OracleType.NVarChar).Value = dwData["WBBSPKZ"].ToString();
            or1.Parameters.Add("WBBCUKZ", OracleType.NVarChar).Value = dwData["WBBCUKZ"].ToString();
            or1.Parameters.Add("WBBDISPOART", OracleType.NVarChar).Value = dwData["WBBDISPOART"].ToString();
            or1.Parameters.Add("WBBDISPOVAR", OracleType.NVarChar).Value = dwData["WBBDISPOVAR"].ToString();
            or1.Parameters.Add("WBBAUSFFRB", OracleType.NVarChar).Value = dwData["WBBAUSFFRB"].ToString();
            or1.Parameters.Add("WBBAUSFGRI", OracleType.NVarChar).Value = dwData["WBBAUSFGRI"].ToString();
            or1.Parameters.Add("WBBAUSFQUAL", OracleType.NVarChar).Value = dwData["WBBAUSFQUAL"].ToString();
            or1.Parameters.Add("WBBQUALST", OracleType.NVarChar).Value = dwData["WBBQUALST"].ToString();
            or1.Parameters.Add("WBBQPKT", OracleType.NVarChar).Value = dwData["WBBQPKT"].ToString();
            or1.Parameters.Add("WBBQPKTH", OracleType.NVarChar).Value = dwData["WBBQPKTH"].ToString();
            or1.Parameters.Add("WBBQPKTL", OracleType.NVarChar).Value = dwData["WBBQPKTL"].ToString();
            or1.Parameters.Add("WBBQPKTLH", OracleType.NVarChar).Value = dwData["WBBQPKTLH"].ToString();
            or1.Parameters.Add("WBBVB", OracleType.NVarChar).Value = dwData["WBBVB"].ToString();
            or1.Parameters.Add("WBBVG", OracleType.NVarChar).Value = dwData["WBBVG"].ToString();
            or1.Parameters.Add("WBBVLVB", OracleType.NVarChar).Value = dwData["WBBVLVB"].ToString();
            or1.Parameters.Add("WBBVLVG", OracleType.NVarChar).Value = dwData["WBBVLVG"].ToString();
            or1.Parameters.Add("WBBVLSACHB", OracleType.NVarChar).Value = dwData["WBBVLSACHB"].ToString();
            or1.Parameters.Add("WBBVLGEGEN", OracleType.NVarChar).Value = dwData["WBBVLGEGEN"].ToString();
            or1.Parameters.Add("WBBPRKUNDNR", OracleType.NVarChar).Value = dwData["WBBPRKUNDNR"].ToString();
            or1.Parameters.Add("WBBGENNR", OracleType.NVarChar).Value = dwData["WBBGENNR"].ToString();
            or1.Parameters.Add("WBBELOA", OracleType.NVarChar).Value = dwData["WBBELOA"].ToString();
            or1.Parameters.Add("WBBELOB", OracleType.NVarChar).Value = dwData["WBBELOB"].ToString();
            or1.Parameters.Add("WBBURAUFKRS", OracleType.NVarChar).Value = dwData["WBBURAUFKRS"].ToString();
            or1.Parameters.Add("WBBURAUFLFD", OracleType.NVarChar).Value = dwData["WBBURAUFLFD"].ToString();
            or1.Parameters.Add("WBBURAUFPOS", OracleType.NVarChar).Value = dwData["WBBURAUFPOS"].ToString();
            or1.Parameters.Add("WBBVKNPOS", OracleType.NVarChar).Value = dwData["WBBVKNPOS"].ToString();
            or1.Parameters.Add("WBBURLAND", OracleType.NVarChar).Value = dwData["WBBURLAND"].ToString();
            or1.Parameters.Add("WBBVERZKZ", OracleType.NVarChar).Value = dwData["WBBVERZKZ"].ToString();
            or1.Parameters.Add("WBBTSTKLG", OracleType.NVarChar).Value = dwData["WBBTSTKLG"].ToString();
            or1.Parameters.Add("WBBTANZ", OracleType.NVarChar).Value = dwData["WBBTANZ"].ToString();
            or1.Parameters.Add("WBBURPOS", OracleType.NVarChar).Value = dwData["WBBURPOS"].ToString();
            or1.Parameters.Add("WBBTEILPOS", OracleType.NVarChar).Value = dwData["WBBTEILPOS"].ToString();
            or1.Parameters.Add("WBBECKZ", OracleType.NVarChar).Value = dwData["WBBECKZ"].ToString();
            or1.Parameters.Add("WBBTLGAFOLGE", OracleType.NVarChar).Value = dwData["WBBTLGAFOLGE"].ToString();
            or1.Parameters.Add("WBBZMT", OracleType.NVarChar).Value = dwData["WBBZMT"].ToString();
            or1.Parameters.Add("WBBANZSNT", OracleType.NVarChar).Value = dwData["WBBANZSNT"].ToString();
            or1.Parameters.Add("WBBTLBRT", OracleType.NVarChar).Value = dwData["WBBTLBRT"].ToString();
            or1.Parameters.Add("WBBTLSTKLG", OracleType.NVarChar).Value = dwData["WBBTLSTKLG"].ToString();
            or1.Parameters.Add("WBBTLRICHT", OracleType.NVarChar).Value = dwData["WBBTLRICHT"].ToString();
            or1.Parameters.Add("WBBDRKZ1", OracleType.NVarChar).Value = dwData["WBBDRKZ1"].ToString();
            or1.Parameters.Add("WBBDRKZ2", OracleType.NVarChar).Value = dwData["WBBDRKZ2"].ToString();
            or1.Parameters.Add("WBBEINDAT", OracleType.NVarChar).Value = dwData["WBBEINDAT"].ToString();
            or1.Parameters.Add("WBBWSTKLG", OracleType.NVarChar).Value = dwData["WBBWSTKLG"].ToString();
            or1.Parameters.Add("WBBWBRT", OracleType.NVarChar).Value = dwData["WBBWBRT"].ToString();
            or1.Parameters.Add("WBBWBMNRKRS", OracleType.NVarChar).Value = dwData["WBBWBMNRKRS"].ToString();
            or1.Parameters.Add("WBBWBMLFDNR", OracleType.NVarChar).Value = dwData["WBBWBMLFDNR"].ToString();
            or1.Parameters.Add("WBBWBMPOS", OracleType.NVarChar).Value = dwData["WBBWBMPOS"].ToString();
            or1.Parameters.Add("WBBSCHUSS", OracleType.NVarChar).Value = dwData["WBBSCHUSS"].ToString();
            or1.Parameters.Add("WBBWERKE", OracleType.NVarChar).Value = dwData["WBBWERKE"].ToString();
            or1.Parameters.Add("WBBLIEF", OracleType.NVarChar).Value = dwData["WBBLIEF"].ToString();
            or1.Parameters.Add("WBBBAHN", OracleType.NVarChar).Value = dwData["WBBBAHN"].ToString();
            or1.Parameters.Add("WBBBAHNMAX", OracleType.NVarChar).Value = dwData["WBBBAHNMAX"].ToString();
            or1.Parameters.Add("WBBWLO", OracleType.NVarChar).Value = dwData["WBBWLO"].ToString();
            or1.Parameters.Add("WBBWLB", OracleType.NVarChar).Value = dwData["WBBWLB"].ToString();
            or1.Parameters.Add("WBBWLP", OracleType.NVarChar).Value = dwData["WBBWLP"].ToString();
            or1.Parameters.Add("WBBWAUFBKZ", OracleType.NVarChar).Value = dwData["WBBWAUFBKZ"].ToString();
            or1.Parameters.Add("WBBKANTE", OracleType.NVarChar).Value = dwData["WBBKANTE"].ToString();
            or1.Parameters.Add("WBBSOLLKZ", OracleType.NVarChar).Value = dwData["WBBSOLLKZ"].ToString();
            or1.Parameters.Add("WBBMATAB", OracleType.NVarChar).Value = dwData["WBBMATAB"].ToString();
            or1.Parameters.Add("WBBWJJJJ", OracleType.NVarChar).Value = dwData["WBBWJJJJ"].ToString();
            or1.Parameters.Add("WBBWBNR", OracleType.NVarChar).Value = dwData["WBBWBNR"].ToString();
            or1.Parameters.Add("WBBFLZZUGDAT", OracleType.NVarChar).Value = dwData["WBBFLZZUGDAT"].ToString();
            or1.Parameters.Add("WBBISTKLGFA", OracleType.NVarChar).Value = dwData["WBBISTKLGFA"].ToString();
            or1.Parameters.Add("WBBISTKLGF", OracleType.NVarChar).Value = dwData["WBBISTKLGF"].ToString();
            or1.Parameters.Add("WBBFRTWSKZ", OracleType.NVarChar).Value = dwData["WBBFRTWSKZ"].ToString();
            or1.Parameters.Add("WBBLTPOS", OracleType.NVarChar).Value = dwData["WBBLTPOS"].ToString();
            or1.Parameters.Add("WBBILGFBT", OracleType.NVarChar).Value = dwData["WBBILGFBT"].ToString();
            or1.Parameters.Add("WBBILGRBT", OracleType.NVarChar).Value = dwData["WBBILGRBT"].ToString();
            or1.Parameters.Add("WBBIBRTFV", OracleType.NVarChar).Value = dwData["WBBIBRTFV"].ToString();
            or1.Parameters.Add("WBBIBRTFB", OracleType.NVarChar).Value = dwData["WBBIBRTFB"].ToString();
            or1.Parameters.Add("WBBFEUCHTE", OracleType.NVarChar).Value = dwData["WBBFEUCHTE"].ToString();
            or1.Parameters.Add("WBBLIEFSCH", OracleType.NVarChar).Value = dwData["WBBLIEFSCH"].ToString();
            or1.Parameters.Add("WBBKDPART", OracleType.NVarChar).Value = dwData["WBBKDPART"].ToString();
            or1.Parameters.Add("WBBSCHLICHTEKZ", OracleType.NVarChar).Value = dwData["WBBSCHLICHTEKZ"].ToString();
            or1.Parameters.Add("WBBASWAKZ", OracleType.NVarChar).Value = dwData["WBBASWAKZ"].ToString();
            or1.Parameters.Add("WBBASART", OracleType.NVarChar).Value = dwData["WBBASART"].ToString();
            or1.Parameters.Add("WBBASVAR", OracleType.NVarChar).Value = dwData["WBBASVAR"].ToString();
            or1.Parameters.Add("WBBFARBEALT", OracleType.NVarChar).Value = dwData["WBBFARBEALT"].ToString();
            or1.Parameters.Add("WBBCOLALT", OracleType.NVarChar).Value = dwData["WBBCOLALT"].ToString();
            or1.Parameters.Add("WBBDESSALT", OracleType.NVarChar).Value = dwData["WBBDESSALT"].ToString();
            or1.Parameters.Add("WBBBESALT", OracleType.NVarChar).Value = dwData["WBBBESALT"].ToString();
            or1.Parameters.Add("WBBZUSTANDA", OracleType.NVarChar).Value = dwData["WBBZUSTANDA"].ToString();
            or1.Parameters.Add("WBBMASSKZ", OracleType.NVarChar).Value = dwData["WBBMASSKZ"].ToString();
            or1.Parameters.Add("WBBFJJJJ", OracleType.NVarChar).Value = dwData["WBBFJJJJ"].ToString();
            or1.Parameters.Add("WBBFBNR", OracleType.NVarChar).Value = dwData["WBBFBNR"].ToString();
            or1.Parameters.Add("WBBRETOURKZ", OracleType.NVarChar).Value = dwData["WBBRETOURKZ"].ToString();
            or1.Parameters.Add("WBBREAUFKRS", OracleType.NVarChar).Value = dwData["WBBREAUFKRS"].ToString();
            or1.Parameters.Add("WBBREAUFLFD", OracleType.NVarChar).Value = dwData["WBBREAUFLFD"].ToString();
            or1.Parameters.Add("WBBREAUFPOS", OracleType.NVarChar).Value = dwData["WBBREAUFPOS"].ToString();
            or1.Parameters.Add("WBBREAFOLGE", OracleType.NVarChar).Value = dwData["WBBREAFOLGE"].ToString();
            or1.Parameters.Add("WBBTPA", OracleType.NVarChar).Value = dwData["WBBTPA"].ToString();
            or1.Parameters.Add("WBBKOMMNR", OracleType.NVarChar).Value = dwData["WBBKOMMNR"].ToString();
            or1.Parameters.Add("WBBALIEFSCH", OracleType.NVarChar).Value = dwData["WBBALIEFSCH"].ToString();
            or1.Parameters.Add("WBBPACKNR", OracleType.NVarChar).Value = dwData["WBBPACKNR"].ToString();
            or1.Parameters.Add("WBBPACKAUTO", OracleType.NVarChar).Value = dwData["WBBPACKAUTO"].ToString();
            or1.Parameters.Add("WBBRUEKZ", OracleType.NVarChar).Value = dwData["WBBRUEKZ"].ToString();
            or1.Parameters.Add("WBBURLB", OracleType.NVarChar).Value = dwData["WBBURLB"].ToString();
            or1.Parameters.Add("WBBURLP", OracleType.NVarChar).Value = dwData["WBBURLP"].ToString();
            or1.Parameters.Add("WBBURAKZ", OracleType.NVarChar).Value = dwData["WBBURAKZ"].ToString();
            or1.Parameters.Add("WBBVERSDAT", OracleType.NVarChar).Value = dwData["WBBVERSDAT"].ToString();
            or1.Parameters.Add("WBBVERSANDKZ", OracleType.NVarChar).Value = dwData["WBBVERSANDKZ"].ToString();
            or1.Parameters.Add("WBBURLIEFSCH", OracleType.NVarChar).Value = dwData["WBBURLIEFSCH"].ToString();
            or1.Parameters.Add("WBBARECHNR", OracleType.NVarChar).Value = dwData["WBBARECHNR"].ToString();
            or1.Parameters.Add("WBBFERTKZ", OracleType.NVarChar).Value = dwData["WBBFERTKZ"].ToString();
            or1.Parameters.Add("WBBEGKZ", OracleType.NVarChar).Value = dwData["WBBEGKZ"].ToString();
            or1.Parameters.Add("WBBBEM", OracleType.NVarChar).Value = dwData["WBBBEM"].ToString();
            or1.Parameters.Add("WBBTXSCHL", OracleType.NVarChar).Value = dwData["WBBTXSCHL"].ToString();
            or1.Parameters.Add("WBBHHK1", OracleType.NVarChar).Value = dwData["WBBHHK1"].ToString();
            or1.Parameters.Add("WBBHHK2", OracleType.NVarChar).Value = dwData["WBBHHK2"].ToString();
            or1.Parameters.Add("WBBHHK3", OracleType.NVarChar).Value = dwData["WBBHHK3"].ToString();
            or1.Parameters.Add("WBBHHK4", OracleType.NVarChar).Value = dwData["WBBHHK4"].ToString();
            or1.Parameters.Add("WBBHHK5", OracleType.NVarChar).Value = dwData["WBBHHK5"].ToString();
            or1.Parameters.Add("WBBHHK6", OracleType.NVarChar).Value = dwData["WBBHHK6"].ToString();
            or1.Parameters.Add("WBBHHK7", OracleType.NVarChar).Value = dwData["WBBHHK7"].ToString();
            or1.Parameters.Add("WBBHHK8", OracleType.NVarChar).Value = dwData["WBBHHK8"].ToString();
            or1.Parameters.Add("WBBHHK9", OracleType.NVarChar).Value = dwData["WBBHHK9"].ToString();
            or1.Parameters.Add("WBBHHK10", OracleType.NVarChar).Value = dwData["WBBHHK10"].ToString();
            or1.Parameters.Add("WBBHHKG", OracleType.NVarChar).Value = dwData["WBBHHKG"].ToString();
            or1.Parameters.Add("WBBAHK1", OracleType.NVarChar).Value = dwData["WBBAHK1"].ToString();
            or1.Parameters.Add("WBBAHK2", OracleType.NVarChar).Value = dwData["WBBAHK2"].ToString();
            or1.Parameters.Add("WBBAHK3", OracleType.NVarChar).Value = dwData["WBBAHK3"].ToString();
            or1.Parameters.Add("WBBAHK4", OracleType.NVarChar).Value = dwData["WBBAHK4"].ToString();
            or1.Parameters.Add("WBBAHK5", OracleType.NVarChar).Value = dwData["WBBAHK5"].ToString();
            or1.Parameters.Add("WBBAHK6", OracleType.NVarChar).Value = dwData["WBBAHK6"].ToString();
            or1.Parameters.Add("WBBAHK7", OracleType.NVarChar).Value = dwData["WBBAHK7"].ToString();
            or1.Parameters.Add("WBBAHK8", OracleType.NVarChar).Value = dwData["WBBAHK8"].ToString();
            or1.Parameters.Add("WBBAHK9", OracleType.NVarChar).Value = dwData["WBBAHK9"].ToString();
            or1.Parameters.Add("WBBAHK10", OracleType.NVarChar).Value = dwData["WBBAHK10"].ToString();
            or1.Parameters.Add("WBBAHKG", OracleType.NVarChar).Value = dwData["WBBAHKG"].ToString();
            or1.Parameters.Add("WBBABPZAB", OracleType.NVarChar).Value = dwData["WBBABPZAB"].ToString();
            or1.Parameters.Add("WBBABDATAB", OracleType.NVarChar).Value = dwData["WBBABDATAB"].ToString();
            or1.Parameters.Add("WBBNEUBEN", OracleType.NVarChar).Value = dwData["WBBNEUBEN"].ToString();
            or1.Parameters.Add("WBBNEUDAT", OracleType.NVarChar).Value = dwData["WBBNEUDAT"].ToString();
            or1.Parameters.Add("WBBAENDBEN", OracleType.NVarChar).Value = dwData["WBBAENDBEN"].ToString();
            or1.Parameters.Add("WBBAENDDAT", OracleType.NVarChar).Value = dwData["WBBAENDDAT"].ToString();
            or1.Parameters.Add("WBBAENDZL", OracleType.NVarChar).Value = dwData["WBBAENDZL"].ToString();
            or1.Parameters.Add("WBBWS", OracleType.NVarChar).Value = dwData["WBBWS"].ToString();
            or1.Parameters.Add("WBBWSNO", OracleType.NVarChar).Value = dwData["WBBWSNO"].ToString();
            or1.Parameters.Add("WBBFILLER", OracleType.NVarChar).Value = dwData["WBBFILLER"].ToString();
            #endregion

            Connect2Proxy(or1);
        }
    }
}
